TR_CONSTITUENCYCODE_DELETE_VSECONSTITUENCYMAP

                create trigger dbo.TR_CONSTITUENCYCODE_DELETE_VSECONSTITUENCYMAP on dbo.CONSTITUENCYCODE after delete not for replication as begin delete from dbo.VSECONSTITUENCYMAP where CONSTITUENCYID in (select ID from deleted) end;