mysql 查找外键

原文

数据库mydb中，所有的表，它们包含外键到表mytable任何字段。

SELECT TABLE_NAME, COUNT(*) AS reference_count 
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS 
WHERE CONSTRAINT_SCHEMA = 'mydb' 
    AND REFERENCED_TABLE_NAME = 'mytable' GROUP BY TABLE_NAME;

---