sql语句新建表

create table student

(

sno int indetity(1,1) primary key,

sname nvachar(10),

[money] nvachar(10),

departno int

)

create table sxx

(

departno int primary key,

departname nvachar(10)

)

create table sc

(

sno int,

cname nvarchar(10),

score nvarchar(10)

primary key(sno,cname)  //设置联合主键

)

alter student1 add constraint fk_stu foreign key(departno) references sxx(departno) //设置外键关联

alter sc1 add constraint fk_scstu foreign key(sno) references student1(sno)// 设置外键关联