TR_MARKINGCOLUMNDESCRIPTIONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_MARKINGCOLUMNDESCRIPTIONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.MARKINGCOLUMNDESCRIPTIONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'bc0919c0-a34a-4783-a91e-9a17115bc674' and TABLEENTRYID in (select ID from deleted) end