主表约束从表删除的触发器

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