MySQL find all tables which reference another table with a foreign key constraint

find_all_fk_tables_for_a_table

------------------------------------------------------------------------------
--- select all tables which have FKs that reference a table
------------------------------------------------------------------------------
SELECT *
    FROM information_schema.REFERENTIAL_CONSTRAINTS
    WHERE referenced_table_name LIKE '%{table}%';