TR_CUSTOMFORMRULETARGET_DELETE (Trigger)

         
          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