- select table_schema,table_name from information_schema.tables
- where (table_schema,table_name) not in(
- select distinct table_schema,table_name from information_schema.columns where COLUMN_KEY='PRI'
- )
- and table_schema not in (
- 'sys','mysql','information_schema','performance_schema'
- );
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29254281/viewspace-2146092/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29254281/viewspace-2146092/