TR_SPROPPCHILDCONDITIONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_SPROPPCHILDCONDITIONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.SPROPPCHILDCONDITIONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'a5e5764f-29e5-4395-9a6b-d1a180baa22f' and TABLEENTRYID in (select ID from deleted) end