TR_JOBSCHEDULECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_JOBSCHEDULECODE_DELETE_BBNCCODETABLEIDMAP on dbo.JOBSCHEDULECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '096b2584-d486-411a-88ca-dbd83cb5c45f' and TABLEENTRYID in (select ID from deleted) end