TR_CONSTITUENT_DELETE_SEARCHCONSTITUENT (Trigger)

        
        CREATE trigger TR_CONSTITUENT_DELETE_SEARCHCONSTITUENT on dbo.CONSTITUENT after delete not for replication
        as begin
          if exists (select 1 from sys.TABLES where TYPE = 'U' and NAME = 'SEARCHCONSTITUENT')
            delete from dbo.SEARCHCONSTITUENT
            where CONSTITUENTID in(select ID from deleted)
        end