SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = ‘your_database_name’ – 替换为你的数据库名
AND INDEX_NAME = ‘PRIMARY’
AND TABLE_NAME NOT IN (
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = ‘your_database_name’ – 替换为你的数据库名
AND INDEX_NAME <> ‘PRIMARY’
);