Given a database name and table name, find all tables which have a foreign key constraint with the given table.

related-tables.sql

SELECT
  TABLE_NAME,
  COLUMN_NAME,
  CONSTRAINT_NAME,
  REFERENCED_TABLE_NAME,
  REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_NAME = 'My_Table'
AND TABLE_SCHEMA = 'My_Database';