我在查询分析器里编写了几行创建表的代码,可是在执行的时候却出现不能编译的信息。向大家咨询一下是怎么回事?我刚开始学编写SQL语句,望大家多多指教。
代码如下:
CREAT TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname char(40) unique,
Ssex char(2),
Sdept char(15),
Sage INT
);
CREAT TABLE Course
(Cno char(4) primary key,
Cname char(40),
Cpno char(4),
Ccredit smallint,
foreign key Cpno references on Course(Cno)
/*表级完整性约束条件,Cpno是外码,被参照表是Course,被参照列是Cno*/
);
CREAT TABLE SC
(Sno char(9),
Cno char(4),
Grade smallint,
primary key (Sno,Cno),
foreign key Sno references on Student(Sno),
foreign key Cno references on Course(Cno)
);
错误消息如下
服务器: 消息 156,级别 15,状态 1,行 1
在关键字 'SCHEMA' 附近有语法错误。
代码如下:
CREAT TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname char(40) unique,
Ssex char(2),
Sdept char(15),
Sage INT
);
CREAT TABLE Course
(Cno char(4) primary key,
Cname char(40),
Cpno char(4),
Ccredit smallint,
foreign key Cpno references on Course(Cno)
/*表级完整性约束条件,Cpno是外码,被参照表是Course,被参照列是Cno*/
);
CREAT TABLE SC
(Sno char(9),
Cno char(4),
Grade smallint,
primary key (Sno,Cno),
foreign key Sno references on Student(Sno),
foreign key Cno references on Course(Cno)
);
错误消息如下
服务器: 消息 156,级别 15,状态 1,行 1
在关键字 'SCHEMA' 附近有语法错误。
(Sno CHAR(9) PRIMARY KEY,
Sname char(40) unique,
Ssex char(2),
Sdept char(15),
Sage INT
)
CREATe TABLE Course
(Cno char(4) primary key,
Cname char(40),
Cpno char(4),
Ccredit smallint,
foreign key (Cpno) references Course(Cno)
/*表级完整性约束条件,Cpno是外码,被参照表是Course,被参照列是Cno*/
)
CREATe TABLE SC
(Sno char(9),
Cno char(4),
Grade smallint,
primary key (Sno,Cno),
foreign key (Sno) references Student(Sno),
foreign key (Cno) references Course(Cno)
)godrop table SC,Course,Student