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)