主表约束从表删除_存储过程

主表约束从表删除

/*很久没写触发器了，刚好工作上使用到*/

/*主表为programe，从表为registers，programe的主键为pid，registers的主键为rid，外键为pid*/

/*删除programe记录，同时删除从表regeisters的相关记录*/
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