Mysql外键约束

删除外键约束：
show create table emp（表名）;
| emp | CREATE TABLE emp (
empno int NOT NULL,
ename varchar(10) DEFAULT NULL,
Job varchar(10) DEFAULT NULL,
Mgr int DEFAULT NULL,
Hiredate datetime DEFAULT NULL,
Sal float DEFAULT NULL,
Comm float DEFAULT NULL,
deptno int DEFAULT NULL,
PRIMARY KEY (empno),
KEY Mgr (Mgr),
KEY deptno (deptno),
CONSTRAINT **emp_ibfk_1** FOREIGN KEY (Mgr) REFERENCES emp (empno),
CONSTRAINT **emp_ibfk_2** FOREIGN KEY (deptno) REFERENCES dept (Deptno)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
查出deptno的外键约束名为emp_ibfk_2

删除外键执行alter table emp drop foreign key emp_ibfk_2;

重新加入外键约束：
alter table emp add foreign key(deptno) references dept(deptno);