TR_BATCHCODETABLEFIELDCODE_DELETE_BBNCCODETABLEIDMAP (Trigger)

create trigger TR_BATCHCODETABLEFIELDCODE_DELETE_BBNCCODETABLEIDMAP on dbo.BATCHCODETABLEFIELDCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'ab066a32-f254-43ec-8e6a-25271899daf3' and TABLEENTRYID in (select ID from deleted) end