TR_DESIGNATIONLEVELCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_DESIGNATIONLEVELCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP on dbo.DESIGNATIONLEVELCATEGORYCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '20204242-ba0f-4788-8a88-b235946ebecf' and TABLEENTRYID in (select ID from deleted) end