How to View Tables that Reference a Target Table in MySQL

view-dependent-tables-mysql.sql

-- USAGE
--     call show_references_to('my_much_referenced_table') \G

DELIMITER //

CREATE OR REPLACE PROCEDURE show_references_to(
    my_table_name VARCHAR(255)
    -- , my_column_name VARCHAR(255)
)
BEGIN
    SELECT
        TABLE_NAME,
        COLUMN_NAME,
        CONSTRAINT_NAME,
        REFERENCED_TABLE_NAME,
        REFERENCED_COLUMN_NAME
    FROM
        INFORMATION_SCHEMA.KEY_COLUMN_USAGE
    WHERE
        REFERENCED_TABLE_SCHEMA = (SELECT DATABASE())
        AND REFERENCED_TABLE_NAME = my_table_name
        -- AND REFERENCED_COLUMN_NAME = my_column_name
    ;
END
//

DELIMITER ;

-- REFERENCES
--     https://stackoverflow.com/a/201678/151312