Question

SQL Server2008创建外键

代码如下：
CREATE TABLE S(SNO CHAR(5) PRIMARY KEY,
SNAME CHAR(10),
STATUS SMALLINT,
CITY CHAR(10))

CREATE TABLE P(PNO CHAR(5) PRIMARY KEY,
PNAME CHAR(10),
COLOR CHAR (5),
WEIGHT INT)

CREATE TABLE J(JNO CHAR(5) PRIMARY KEY,
JNAME CHAR(10),
CITY CHAR(10))

CREATE TABLE SPJ(SNO CHAR(5),
PNO CHAR(5),
JNP CHAR(5),
QTY INT,
FOREIGN KEY SNO REFERENCES S(SNO),
FOREIGN KEY PNO REFERENCES P(PNO),
FOREIGN KEY JNO REFERENCES J(JNO))

运行老是出现错误，提示如下：
消息 102，级别 15，状态 1，第 19 行
'SNO' 附近有语法错误。、
有没有人知道是怎么回事啊？

Answer 1

CREATE TABLE S(SNO CHAR(5) PRIMARY KEY,
SNAME CHAR(10),
STATUS SMALLINT,
CITY CHAR(10))

CREATE TABLE P(PNO CHAR(5) PRIMARY KEY,
PNAME CHAR(10),
COLOR CHAR (5),
WEIGHT INT)

CREATE TABLE J(JNO CHAR(5) PRIMARY KEY,
JNAME CHAR(10),
CITY CHAR(10))

CREATE TABLE SPJ(
SNO CHAR(5) FOREIGN KEY REFERENCES S(SNO),
PNO CHAR(5) FOREIGN KEY REFERENCES P(PNO),
JNP CHAR(5) FOREIGN KEY REFERENCES J(JNO),
QTY INT
);