TR_PROSPECTRESEARCHREQUESTPRIORITYCODE_DELETE_BBNCCODETABLEIDMAP (Trigger)

create trigger TR_PROSPECTRESEARCHREQUESTPRIORITYCODE_DELETE_BBNCCODETABLEIDMAP on dbo.PROSPECTRESEARCHREQUESTPRIORITYCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'a76b51de-e242-4ce9-8e88-46e4cd20f5af' and TABLEENTRYID in (select ID from deleted) end