TR_STEWARDSHIPSTEWARDROLECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_STEWARDSHIPSTEWARDROLECODE_DELETE_BBNCCODETABLEIDMAP on dbo.STEWARDSHIPSTEWARDROLECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'b86b8024-de34-4ebc-b84f-c95d742fdd55' and TABLEENTRYID in (select ID from deleted) end