create table student
(sno varchar (9) primary key,
sname varchar(20) unique,
ssex char(2),
sage smallint,
sdept varchar(20));
create table course
(cno varchar(4) primary key,
cname varchar(40),
cpno varchar (4),
ccredit smallint,
foreign key cpno references crouse(cno)
);
create table sc
(sno varchar (7),
cno varchar(4),
grade smallint,
primary key (sno,cno),
foreign key sno references student(sno),
foreign key cno references course(cno)
);
我执行之后出现了如下错误
服务器: 消息 170,级别 15,状态 1,行 12
第 12 行: 'cpno' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 19
第 19 行: 'sno' 附近有语法错误。不知道怎么回事
(sno varchar (9) primary key,
sname varchar(20) unique,
ssex char(2),
sage smallint,
sdept varchar(20));
create table course
(cno varchar(4) primary key,
cname varchar(40),
cpno varchar (4),
ccredit smallint,
foreign key cpno references crouse(cno)
);
create table sc
(sno varchar (7),
cno varchar(4),
grade smallint,
primary key (sno,cno),
foreign key sno references student(sno),
foreign key cno references course(cno)
);
我执行之后出现了如下错误
服务器: 消息 170,级别 15,状态 1,行 12
第 12 行: 'cpno' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 19
第 19 行: 'sno' 附近有语法错误。不知道怎么回事
CREATE TABLE STUDENT
(SNO VARCHAR (9) PRIMARY KEY,
SNAME VARCHAR(20) UNIQUE,
SSEX CHAR(2),
SAGE SMALLINT,
SDEPT VARCHAR(20));
CREATE TABLE COURSE
(CNO VARCHAR(4) PRIMARY KEY,
CNAME VARCHAR(40),
CPNO VARCHAR (4),
CCREDIT SMALLINT,
FOREIGN KEY(CPNO) REFERENCES COURSE(CNO)
);
CREATE TABLE SC
(SNO VARCHAR (9),
CNO VARCHAR(4),
GRADE SMALLINT,
PRIMARY KEY (SNO,CNO),
FOREIGN KEY(SNO) REFERENCES STUDENT(SNO),
FOREIGN KEY(CNO) REFERENCES COURSE(CNO)
);