TR_CUSTOMFORMELEMENT_DELETE

Definition

Copy

          create trigger TR_CUSTOMFORMELEMENT_DELETE on dbo.CUSTOMFORMELEMENT instead of delete not for replication
          as begin
            delete from dbo.CUSTOMFORMRULEACTION
            where RULEACTIONFIELDID in(select [Guid] from deleted)

            delete from dbo.CUSTOMFORMRULETARGET
            where RULETARGETFIELDID in(select [Guid] from deleted)

            delete from dbo.CustomFormElement
            where ID in(select ID from deleted)
          end