Create Trigger T_Del_Programe
On Programe
Instead Of Delete
As
declare @Pid bigint
Select @Pid=Pid from Deleted
Delete From Registers where Pid=@Pid
Delete From Programe where Pid=@Pid
go
主表为 programe,从表为 registers,programe的主键为 pid ,registers的主键为 rid ,外键为 pid ,
要做的是: 删除programe的纪录,同时删除registers 的相关纪录。
注:转自 http://www.cnblogs.com/torome/archive/2008/04/06/532128.html
主表约束从表删除的触发器
最新推荐文章于 2021-04-11 03:25:08 发布