MySQL: How do I find out which tables reference a specific table?

Question

select table_name
from information_schema.KEY_COLUMN_USAGE
where table_schema = 'my_database'
and referenced_table_name = 'my_table_here';

This works.

select table_name 
from information_schema.referential_constraints 
where referenced_table_name = 'parent table here';

If you have phpMyAdmin installed, you can use its designer feature to visualize table relationships.

To use the designer, select a database, then look for the Designer tab.