TR_PDCOMPOSITESEGMENT_DEL

                CREATE trigger [dbo].[TR_PDCOMPOSITESEGMENT_DEL] on [dbo].[PDCOMPOSITESEGMENT]
                  for delete
                  as
                  set nocount on

                  delete t2
                  from deleted t1 inner join dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT t2 on t1.ID = t2.ID