为choose表添加外键约束,约束名为choose_student_fk,外键为student_no,连接到 student表的stuednt_no字段,以下命令正确的是_____。
A.
alter table choose add constraint choose_student_fk FOREIGN KEY (student_no) REFERENCES student(stuednt_no)
B.
alter table choose add constraint choose_student_fk FOREIGN KEY (student_no)
C.
alter table choose add constraint choose_student_fk FOREIGN KEY (student_no) REFERENCES student
D.
alter table choose add constraint choose_student_fk REFERENCES student(stuednt_no)