1.查看被约束表外键相关所有表
select * from information_schema.key_column_usage where referenced_table_name = "被约束表名字"
2.查看外键的具体名称
show create table "被约束表名字"
3.删除外键约束
alter table `约束表名` drop foreign key `外键名字`
1.查看被约束表外键相关所有表
select * from information_schema.key_column_usage where referenced_table_name = "被约束表名字"
2.查看外键的具体名称
show create table "被约束表名字"
3.删除外键约束
alter table `约束表名` drop foreign key `外键名字`