我的Employee表有一个主键列,即(EmpID),它在另外两个表EmployeeEducation表和EmployeeBankInformation表中被引用。 我想删除员工的ID,但是当我运行存储过程时,我的控制器抛出错误,指出由于EmpID列,外键引用约束冲突。 ALTER PROCEDURE [dbo].[RemoveEmployee] @EmpID intAS DELETE FROM Employee WHERE EmpID = @EmpID
DELETE FROM EmployeeEducation WHERE EmpID = @E