create table course
(cno char(4) primary key,
cname char(40),
cpno char(4),
ccredit smallint,
foreign key cpno references course(cno)
);
报错:服务器: 消息 170,级别 15,状态 1,行 6
第 6 行: 'cpno' 附近有语法错误。
(cno char(4) primary key,
cname char(40),
cpno char(4),
ccredit smallint,
foreign key cpno references course(cno)
);
报错:服务器: 消息 170,级别 15,状态 1,行 6
第 6 行: 'cpno' 附近有语法错误。
(cno char(4) primary key,
cname char(40),
cpno char(4),
ccredit smallint
foreign key cpno references course(cno)
);去掉foreign前面的逗号
(cno char(4) primary key,
cname char(40),
cpno char(4) foreign key cpno references course(cno),
ccredit smallint
);
(
cno char(4) primary key,
cname char(40),
cpno char(4) foreign key references course(cno),
ccredit smallint
);
(cno char(4) primary key,
cname char(40),
cpno char(4) foreign key cpno references course(cno)
ccredit smallint);
csdn来大姨妈了素酱紫得