CREATE TABLE EMPLOYEES(
EmployeeNumber INT NOT NULL IDENTITY(1,1)
LastName Char(35) NOT NULL,
FirstName CHAR(35) NOT NULL,
Department CHAR(35) NOT NULL,
CONSTRAINT EMPLOYEE_PK PRIMARY KEY(EmployeeNumber));
CREATE TABLE DEPARTMENT(
DepartmentName CHAR(35) NOT NULL,
Phone CHAR(35) NOT NULL,
BudgetCode CHAR(35) NOT NULL,
CONSTRAINT DEP_PK PRIMARY KEY(DepartmentName));
我忘了把一个部门作为员工的外键,所以我做了
ALTER TABLE EMPLOYEES ADD CONSTRAINT EMP_DEP_FK
FOREIGN KEY(Department) REFERENCES DEPARTMENT(DepartmentName)
这向我展示了:
ALTER TABLE 语句与 FOREIGN KEY 约束冲突 "EMP_DEP_FK"。冲突发生在数据库"WPC"中,表 "哎呀。部门","部门名称"一栏。
您的部门表中有一个拼写错误 ==> DepartmetnName。
应该是部门名称。