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