TR_DENOMINATIONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_DENOMINATIONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.DENOMINATIONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '84e626ab-0e5a-498b-8f04-cc8d93c5dbd3' and TABLEENTRYID in (select ID from deleted) end