MySQL - Get list of tables reference to a table with foreign key

MySQL - Get list of tables reference to a table with foreign key.md

SELECT
    TABLE_SCHEMA AS 'Database',
    TABLE_NAME AS t1,
    REFERENCED_TABLE_NAME AS 't2 (reference table)',
    COLUMN_NAME AS 't1 column',
    REFERENCED_COLUMN_NAME AS 't2 column (reference table)',
    CONSTRAINT_NAME AS 't1 (constrain name)'
FROM
    information_schema.key_column_usage
WHERE
    referenced_table_name IS NOT NULL 
    AND TABLE_SCHEMA = 'database_name'
    AND REFERENCED_TABLE_NAME = 'table_name'