TR_EDUCATIONALSUBDEPARTMENTCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_EDUCATIONALSUBDEPARTMENTCODE_DELETE_BBNCCODETABLEIDMAP on dbo.EDUCATIONALSUBDEPARTMENTCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'fa1a8abb-de22-4398-af1c-cd53cb6f1b28' and TABLEENTRYID in (select ID from deleted) end