select a.table_schema,a.table_name
from information_schema.tables a left outer join information_schema.table_constraints b
on a.table_schema = b.table_schema and a.table_name = b.table_name and b.constraint_name in ('PRIMARY')
where b.table_name is null and a.table_schema not in ('information_schema','performance_schema','test','mysql', 'sys')；