TR_EDUCATIONALHISTORY_DELETE_BBNCEDUCATIONALHISTORYIDMAP (Trigger)

        
CREATE trigger TR_EDUCATIONALHISTORY_DELETE_BBNCEDUCATIONALHISTORYIDMAP on dbo.EDUCATIONALHISTORY after delete not for replication
as begin
  delete from dbo.BBNCEDUCATIONALHISTORYIDMAP
    where EDUCATIONALHISTORYID in (select ID from deleted)
end