SQL Server2005删除触发器

由于当初在设计数据库的时候没有建立主外键关系，导致删除主表后，会在其他表产生许多冗余数据，因此需要添加删除触发器。

create trigger trgContentSet
on contentset
for  Delete
as
delete attendermanger  from attendermanger as a,deleted d where a.d_cid = d.c_id
delete attenderdep from attenderdep as a,deleted d where a.contentset = d.c_id
delete checkdetails from checkdetails as c,deleted d where c.d_cid = d.c_id