TR_TAGCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_TAGCODE_DELETE_BBNCCODETABLEIDMAP on dbo.TAGCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '4a4af59a-db28-416a-8b01-8af33290958b' and TABLEENTRYID in (select ID from deleted) end