求救:一条sql语句的语法问题(请各位大虾给个指点)

[yuzhoulangzi17]

表Quest和其他表Food, ...等都有外键的关联,但是在分析器里改了半天还是有语法问题,请各位大虾给个指点...! 在线等...
use HotelManagerDB
go

create table Quest
(Name char(20)not null,
ID char(20)constraint PK_ID primary key,
RoomID char(10)not null,
Sumtotal money not null,
foreign key(Name)references Food(Name),
foreign key(RoomID)references Food(RoomID),

foreign key(Name)references Car(Name),
foreign key(RoomID)references Car(RoomID),

foreign key(Name)references Copy(Name),
foreign key(RoomID)references Copy(RoomID),

foreign key(Name)references Play(Name),
foreign key(RoomID)references Play(RoomID),

foreign key(Name)references Telepone(Name),
foreign key(RoomID)references Telepone(RoomID)
)
go

[中国风]

语法不正确

[yuzhoulangzi17]

请问能不能帮我改改啊

[中国风]

create table Quest(Name char(20)not null,
ID char(20)constraint PK_ID primary key,
RoomID char(10)not null
foreign key(RoomID)references Car(RoomID),
foreign key(RoomID)references Copy(RoomID),
foreign key(RoomID)references Play(RoomID),
foreign key(RoomID)references Telepone(RoomID),
foreign key(RoomID)references Food(RoomID),
Sumtotal money not null,
name varchar(20) not null
foreign key(Name)references Food(Name),
foreign key(Name)references Car(Name),
foreign key(Name)references Copy(Name),
foreign key(Name)references Play(Name),
foreign key(Name)references Telepone(Name))
楼主首先要确认一下外键表是列名是否存在

[中国风]

好像不行，测试一下先

[zsl5305256]

直接到企业管理器去设置了,要是想看sql脚本,再把它们导出来!

[marco08]

楼主应该检查表是否存在，字段是否为主键或唯一约束

[中国风]

楼主先把Quest表建好（不用增加外键）
然后到企业管理器中添加外键
步骤:
在企业管理—选择quest表—右健—设计表—右键(选择关系)—然后新增就行了—手动选择表的外键