TR_REJECTIONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_REJECTIONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.REJECTIONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '7f802a95-73e4-4f72-8b48-b41774bfd384' and TABLEENTRYID in (select ID from deleted) end