TR_BENEFITCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_BENEFITCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP on dbo.BENEFITCATEGORYCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'afda4834-8529-4e84-a746-ae55c4c5c933' and TABLEENTRYID in (select ID from deleted) end