TR_PDACCOUNTSEGMENT_DEL

        create trigger [dbo].[TR_PDACCOUNTSEGMENT_DEL] on [dbo].[PDACCOUNTSEGMENT]
          for delete
          as
          set nocount on

          delete t2
          from deleted t1 inner join dbo.PDACCOUNTSEGMENTVALUE t2 on t1.PDACCOUNTSEGMENTVALUEID = t2.ID
          where not exists (select * from PDACCOUNTSEGMENT where PDACCOUNTSEGMENTVALUEID = t1.PDACCOUNTSEGMENTVALUEID)