TR_NAMINGOPPLOCATIONSTATUSCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_NAMINGOPPLOCATIONSTATUSCODE_DELETE_BBNCCODETABLEIDMAP on dbo.NAMINGOPPLOCATIONSTATUSCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'a9b1aa24-26c5-49d8-ab4e-94b091c85e98' and TABLEENTRYID in (select ID from deleted) end