查看实例上面无主键的表

select t1.table_schema,t1.table_name from information_schema.tables t1 left outer join information_schema.TABLE_CONSTRAINTS t2   

on t1.table_schema = t2.TABLE_SCHEMA and t1.table_name = t2.TABLE_NAME and t2.CONSTRAINT_NAME in( 'PRIMARY')

where t2.table_name is null and t1.TABLE_SCHEMA not in ('information_schema','performance_schema','test','mysql')and
t1.table_schema not like '%0%' and t1.table_name like '%0%';

 

posted @ 2017-07-25 15:22  sunss  阅读(291)  评论(0编辑  收藏  举报