SELECT t.table_schema, t.table_name, t.engine
FROM information_schema.tables AS t
LEFT JOIN information_schema.key_column_usage AS i ON t.table_schema = i.table_schema AND t.table_name = i.table_name AND i.constraint_name = 'PRIMARY'
WHERE i.constraint_name IS NULL
AND t.table_schema NOT IN ('information_schema', 'mysql')
;