MySQLで外部キーの一覧を取得する

mysql_foreign_key_list_sql.md

あるカラムを参照する外部キーの一覧を取得する

SELECT tb1.TABLE_NAME,
       tb1.COLUMN_NAME,
       tb1.CONSTRAINT_NAME,
       tb1.REFERENCED_TABLE_NAME,
       tb1.REFERENCED_COLUMN_NAME,
       tb2.UPDATE_RULE,
       tb2.DELETE_RULE
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS tb1
         INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS tb2 ON tb1.CONSTRAINT_NAME = tb2.CONSTRAINT_NAME
WHERE REFERENCED_TABLE_SCHEMA = 'database_name'
  AND tb1.REFERENCED_TABLE_NAME = 'table_name'
  AND REFERENCED_COLUMN_NAME = 'column_name'