select table_schema,table_name from information_schema.tables where table_name not in(select distinct table_name from information_schema.columns where COLUMN_KEY='PRI') and table_schema not in('mysql','sys','information_schema','performance_schema');