MySQL: How do I find out which tables reference a specific table?
SELECT TABLE_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = 'your_schema_name'
AND REFERENCED_TABLE_NAME = 'your_table_name';
This works.
select table_name
from information_schema.referential_constraints
where referenced_table_name = 'parent table here';