TR_PROJECTDEPARTMENTCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_PROJECTDEPARTMENTCODE_DELETE_BBNCCODETABLEIDMAP on dbo.PROJECTDEPARTMENTCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '1365379a-20a2-4fd9-98e6-93c4d19a5dab' and TABLEENTRYID in (select ID from deleted) end