if exists(select * from sysobjects where name='Room')
drop table Room
go
create table Room
(
RoomID int identity(1,1)
constraint PK_RoomID primary key,
Number varchar(50),
TypeID int
constraint FK_TypeID foreign key references RoomType(TypeID),
BedNumber int
constraint CK_BedNumber check(BedNumber>0),
Description varchar(50)
constraint DF_Description default('设施完好'),
State varchar(20),
constraint CK_State check(State in('入住','空闲','维修'))
constraint DF_State default('空闲'),
GuestNumber int
constraint CK_GuestNumber check(GuestNumber>=0)
constraint DF_GuestNumber default(0)
)
消息 156,级别 15,状态 1,第 14 行
关键字 'constraint' 附近有语法错误。
drop table Room
go
create table Room
(
RoomID int identity(1,1)
constraint PK_RoomID primary key,
Number varchar(50),
TypeID int
constraint FK_TypeID foreign key references RoomType(TypeID),
BedNumber int
constraint CK_BedNumber check(BedNumber>0),
Description varchar(50)
constraint DF_Description default('设施完好'),
State varchar(20),
constraint CK_State check(State in('入住','空闲','维修'))
constraint DF_State default('空闲'),
GuestNumber int
constraint CK_GuestNumber check(GuestNumber>=0)
constraint DF_GuestNumber default(0)
)
消息 156,级别 15,状态 1,第 14 行
关键字 'constraint' 附近有语法错误。
drop table Room
go
create table Room
(
RoomID int identity(1,1)
constraint PK_RoomID primary key,
Number varchar(50),
TypeID int
constraint FK_TypeID foreign key references RoomType(TypeID),
BedNumber int
constraint CK_BedNumber check(BedNumber>0),
Description varchar(50)
constraint DF_Description default('设施完好'),
State varchar(20)
constraint CK_State check(State in('入住','空闲','维修'))
constraint DF_State default('空闲'),
GuestNumber int
constraint CK_GuestNumber check(GuestNumber>=0)
constraint DF_GuestNumber default(0)
)
if exists(select * from sysobjects where name='Room')
drop table Room
go
create table Room
(
RoomID int identity(1,1)
constraint PK_RoomID primary key,
Number varchar(50),
TypeID int
constraint FK_TypeID foreign key references RoomType(TypeID),
BedNumber int
constraint CK_BedNumber check(BedNumber>0),
Description varchar(50)
constraint DF_Description default('设施完好'),
State varchar(20),--这多了个逗号
constraint CK_State check(State in('入住','空闲','维修'))
constraint DF_State default('空闲'),
GuestNumber int
constraint CK_GuestNumber check(GuestNumber>=0)
constraint DF_GuestNumber default(0)
)