TR_REVENUESPLITBUSINESSUNITOVERRIDECODE_DELETE_BBNCCODETABLEIDMAP (Trigger)

create trigger TR_REVENUESPLITBUSINESSUNITOVERRIDECODE_DELETE_BBNCCODETABLEIDMAP on dbo.REVENUESPLITBUSINESSUNITOVERRIDECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'e6c65a44-7b25-4d38-a740-835c4bde4029' and TABLEENTRYID in (select ID from deleted) end