Question

SQL建表语句，有主外键

Answer 1

create table t_tablename
(
id int idname primary key identity(1,1),
name varchar(20) not null
studentId int foreign key (**id)

或者：atler table score
add constraint FK_Sno foreign key(S_no) references student(S_no)
add constraint FK_Cno foreign key(C_no) references course(C_no)
)