查询数据库中没有设置主键的表

最新推荐文章于 2024-01-25 09:30:52 发布

没有昵称的打工仔

最新推荐文章于 2024-01-25 09:30:52 发布

阅读量610

点赞数

分类专栏：工作总结记录文章标签： sql 数据库 mysql

本文链接：https://blog.csdn.net/weixin_43522117/article/details/126096985

版权

工作总结同时被 2 个专栏收录

23 篇文章 2 订阅

订阅专栏

记录

9 篇文章 0 订阅

订阅专栏

SELECT a.TABLE_SCHEMA,a.TABLE_NAME FROM   (SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ( 'mysql', 'information_schema', 'performance_schema', 'sys', 'sysdb' )) AS a
   LEFT JOIN (SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'
   AND TABLE_SCHEMA NOT IN ( 'mysql', 'information_schema', 'performance_schema', 'sys', 'sysdb' )) AS b ON a.TABLE_SCHEMA = b.TABLE_SCHEMA
   AND a.TABLE_NAME = b.TABLE_NAME WHERE b.TABLE_NAME IS NULL;

查询结果：