SQL Server2005删除触发器

最新推荐文章于 2022-02-25 23:02:56 发布

ningkun123

最新推荐文章于 2022-02-25 23:02:56 发布

阅读量95

点赞数

分类专栏：数据库文章标签： SQL C C++ C#

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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

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