TR_PROSPECTRESEARCHREQUESTSOURCECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTRESEARCHREQUESTSOURCECODE_DELETE_BBNCCODETABLEIDMAP on dbo.PROSPECTRESEARCHREQUESTSOURCECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '88966cbf-bfac-44cd-88b9-9bb1ea0de491' and TABLEENTRYID in (select ID from deleted) end