TR_PDCOMPOSITESEGMENT_DEL (Trigger)

                        
                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