1SELECT
2 TABLE_NAME,
3 COLUMN_NAME,
4 CONSTRAINT_NAME,
5 REFERENCED_TABLE_NAME,
6 REFERENCED_COLUMN_NAME
7FROM
8 INFORMATION_SCHEMA.KEY_COLUMN_USAGE
9WHERE
10 REFERENCED_TABLE_SCHEMA = 'db_name'
11 AND REFERENCED_TABLE_NAME = 'table_name';
12