TR_SPROPPNOTETYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_SPROPPNOTETYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.SPROPPNOTETYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '4ca73726-4511-496b-8a2b-fa44999832f2' and TABLEENTRYID in (select ID from deleted) end