推荐下载
-
2020-05-12 浏览：789
-
2020-04-04 浏览：654
-
2020-05-06 浏览：560
-
2020-05-08 浏览：545
-
2020-05-12 浏览：543
mysql 找出外键等约束
发布时间:2021-05-01
select
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA ='vhr' AND
TABLE_NAME = 'employee';
Result：
此时如果想删除和posId相关的外键，只需要 alter table employee drop foreign key employee_ibfk_3;
找出以employee为REFERENCED_TABLE的所有约束
select TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where CONSTRAINT_SCHEMA ='vhr' AND REFERENCED_TABLE_NAME = 'employee';Result:
