TR_PROSPECTRESEARCHREQUESTSTATUSCHANGECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTRESEARCHREQUESTSTATUSCHANGECODE_DELETE_BBNCCODETABLEIDMAP on dbo.PROSPECTRESEARCHREQUESTSTATUSCHANGECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '2b455e0c-4cf6-4f11-84c8-834b07e63d7f' and TABLEENTRYID in (select ID from deleted) end