Selecting all tables that reference a specific foreign key value in MySQL

Renaming Primary Keys and Foreign Keys in a One-to-Many Relationship Without Breaking Constraints

Understanding SQL Primary Keys Foreign Keys and Table Dependencies for Stronger Database Designs