TR_DECEASEDSOURCECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_DECEASEDSOURCECODE_DELETE_BBNCCODETABLEIDMAP on dbo.DECEASEDSOURCECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '35bcd1f6-a60b-473e-a950-a4b8f0f55cc7' and TABLEENTRYID in (select ID from deleted) end