mysql查询某张表的所有外键

mysql查询某张表的所有外键

select
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME
from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA ='数据库' AND
REFERENCED_TABLE_NAME = '表名';