TR_OPPORTUNITYDESIGNATIONFMCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_OPPORTUNITYDESIGNATIONFMCODE_DELETE_BBNCCODETABLEIDMAP on dbo.OPPORTUNITYDESIGNATIONFMCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '4124163f-9667-4a45-bb9f-62c0643f2d3c' and TABLEENTRYID in (select ID from deleted) end