SELECT
a.CONSTRAINT_NAME,
b.TABLE_NAME,
b.TABLE_SCHEMA
FROM
information_schema.REFERENTIAL_CONSTRAINTS a,
information_schema. TABLES b
WHERE
a.TABLE_NAME = b.TABLE_NAME
AND b.TABLE_SCHEMA = 'XXX';
Mysql查所有外键
最新推荐文章于 2021-05-25 14:39:06 发布
SELECT
a.CONSTRAINT_NAME,
b.TABLE_NAME,
b.TABLE_SCHEMA
FROM
information_schema.REFERENTIAL_CONSTRAINTS a,
information_schema. TABLES b
WHERE
a.TABLE_NAME = b.TABLE_NAME
AND b.TABLE_SCHEMA = 'XXX';