select
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA ='dc2018' AND
REFERENCED_TABLE_NAME = 't_jcsj_rsxx_5';
mysql 查询当前表是哪些其他表的外键
最新推荐文章于 2024-02-28 20:31:41 发布