sql 建库建表语句

create database stuinfo
use stuinfo

create table major(
mno int,
mname varchar(20),
primary key(mno)

)

select * from major

create table stu(
sno int,
sname varchar(30),
age smallint,
sex bit,
mno int,
primary key(sno),
foreign key(mno) references major(mno)

)

select * from stu

create table cou(
cno int,
cname varchar(30),
ctime smallint,
ccredit decimal(4,2),
primary key(cno)

)

select * from cou
—外键最好复制
create table sc(
sno int,
cno int,
grade decimal(5,2)
primary key(sno,cno)
foreign key(sno) references stu(sno)

)
----对sc表加一个外键

alter table sc add constraint fk_sc foreign key(cno) references cou(cno)