TR_CUSTOMFORMRULETARGET_DELETE
Definition
Copy
CREATE trigger TR_CUSTOMFORMRULETARGET_DELETE on dbo.CUSTOMFORMRULETARGET after delete not for replication
as begin
delete from dbo.CUSTOMFORMRULEACTION
where ID in(select action.ID from dbo.CUSTOMFORMRULEACTION action
left outer join CUSTOMFORMRULETARGET target on action.ID = target.RULEACTIONID
where target.RULEACTIONID is null and action.CUSTOMFORMFEEID is null)
end