TR_EDUCATIONALCOLLEGECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_EDUCATIONALCOLLEGECODE_DELETE_BBNCCODETABLEIDMAP on dbo.EDUCATIONALCOLLEGECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'ebfa1b93-d15e-4796-a10f-ceea00f11498' and TABLEENTRYID in (select ID from deleted) end