Question

oracle数据库？

有班级信息表ClassInfo,班主任信息表TeacherInfo 怎么设置班主任ID，外键，引用TeacherInfo表的主键TeacherID

Answer 1

alter table ClassInfo
add constraint kf_CT foreign key (TeacherID)
references TeacherInfo (TeacherID);