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