Copy Code Trigger Definition 

        
        CREATE trigger TR_ALIAS_DELETE_SEARCHCONSTITUENT on dbo.ALIAS after delete not for replication
        as begin
          if isnull(context_info(),0x)<>0xE2DF375A033A104382689B8EAC5165AD
            delete from dbo.SEARCHCONSTITUENT
            where ALIASID in(select ID from deleted);
        end