SELECT C.TABLE_SCHEMA 拥有者,

C.REFERENCED_TABLE_NAME 父表名称 ,大佬们都在玩{ 精选官网网址: www.vip333.Co }值得信任的品牌平台!

C.REFERENCED_COLUMN_NAME 父表字段 ,

C.TABLE_NAME 子表名称,

C.COLUMN_NAME 子表字段,

C.CONSTRAINT_NAME 约束名,

T.TABLE_COMMENT 表注释,

R.UPDATE_RULE 约束更新规则,

R.DELETE_RULE 约束删除规则

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE C大佬们都在玩{ 精选官网网址: www.vip333.Co }值得信任的品牌平台!

JOIN INFORMATION_SCHEMA. TABLES T

ON T.TABLE_NAME = C.TABLE_NAME

JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS R

ON R.TABLE_NAME = C.TABLE_NAME

AND R.CONSTRAINT_NAME = C.CONSTRAINT_NAME

AND R.REFERENCED_TABLE_NAME = C.REFERENCED_TABLE_NAME

WHERE C.REFERENCED_TABLE_NAME IS NOT NULL

and C.TABLE_SCHEMA = '库名'

and C.REFERENCED_TABLE_NAME = '表名'

ALTER TABLE ${表名} DROP FOREIGN KEY ${外键名};大佬们都在玩{ 精选官网网址: www.vip333.Co }值得信任的品牌平台!