触发器级联删除与外键冲突?
大虾:
如下两个表:
create table Company(
ComId char(10) not null,
Name char(50),
primary key(ComId)
);
create table Employee(
EmpId char(10) not null,
ComId char(10) not null,
primary key(EmpId)
foreign key(ComId) references Company(ComId)
);
如果我删除一个公司,那么属于本公司的职员也要删除,照书写了个触发器:
create trigger trDel on Company for delete
as
if @@rowcount=0
return
delete employee
from deleted d,employee e
where d.comid=e.comid
if @@error!=0
begin
raiserror("Error Encountered in trigger processing",16,1)
rollback tran
return
end
return
可是我根本无法删除Company和Employee的内容,SQL Server报告外键约束冲突:
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_ComId'...
也就是触发器根本没触发...
请大虾为小弟指点迷津!