show_list_of_tables_without_primary_keys.sql

SELECT
    TABLE_SCHEMA,
    TABLE_NAME
FROM
     INFORMATION_SCHEMA.TABLES
WHERE
     TABLE_TYPE = 'BASE TABLE'
     AND TABLE_SCHEMA = '<database name>'
     AND TABLE_NAME NOT IN (
         SELECT DISTINCT TABLE_NAME
         FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
         WHERE CONSTRAINT_NAME = 'PRIMARY');