要设置SR_Name不可重复,但不能是主键,SR_ID已经是主键了。
设置后要求出现这样的SQL语句:
create table CM_StepRecord (
SR_ID int not null,
SR_Name varchar(20) null unique,
SR_Mark varchar(50) null,
constraint PK_CM_STEPRECORD primary key (SR_ID)
)
go我现在加了个索引,出现的语句是create table CM_StepRecord (
SR_ID int not null,
SR_Name varchar(20) null,
SR_Mark varchar(50) null,
constraint PK_CM_STEPRECORD primary key (SR_ID)
)
gocreate unique index Index_1 on CM_StepRecord (
SR_Name ASC
)
go
设置后要求出现这样的SQL语句:
create table CM_StepRecord (
SR_ID int not null,
SR_Name varchar(20) null unique,
SR_Mark varchar(50) null,
constraint PK_CM_STEPRECORD primary key (SR_ID)
)
go我现在加了个索引,出现的语句是create table CM_StepRecord (
SR_ID int not null,
SR_Name varchar(20) null,
SR_Mark varchar(50) null,
constraint PK_CM_STEPRECORD primary key (SR_ID)
)
gocreate unique index Index_1 on CM_StepRecord (
SR_Name ASC
)
go
http://topic.csdn.net/u/20081120/14/9be0dcd2-f932-4033-a95d-2eac7ad46356.html