重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: MySQL下批量排查无主键表 [打印本页]

---

作者: jiawang    时间: 2025-10-10 00:02
标题: MySQL下批量排查无主键表
SELECT TABLE_SCHEMA, TABLE_NAME
FROM information_schema.tables t
WHERE t.TABLE_SCHEMA NOT IN ('mysql','information_schema','performance_schema','sys')
  AND NOT EXISTS (
    SELECT 1 FROM information_schema.table_constraints tc
    WHERE tc.table_schema=t.table_schema
      AND tc.table_name=t.table_name
      AND tc.constraint_type='PRIMARY KEY'
  );
可快速列出所有无主键表，建议尽快修复。

---

欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2