取掉DESC : ALTER TABLE [Topic] WITH NOCHECK ADD CONSTRAINT [PK_Topic] PRIMARY KEY CLUSTERED ( [TopicID] ) ON [PRIMARY]
取掉DESC : ALTER TABLE [Topic] WITH NOCHECK ADD CONSTRAINT [PK_Topic] PRIMARY KEY CLUSTERED ( [TopicID] ) ON [PRIMARY]
我是在新建的数据库里执行的,去掉Desc不出错,可加上就出错,您的mssql是2000吗?
sqlserver2000下是对的:create table topic (TopicID int not null)go ALTER TABLE [Topic] WITH NOCHECK ADD CONSTRAINT [PK_Topic] PRIMARY KEY CLUSTERED ( [TopicID] DESC ) ON [PRIMARY] go drop table topic
ALTER TABLE [Topic] WITH NOCHECK ADD
CONSTRAINT [PK_Topic] PRIMARY KEY CLUSTERED
(
[TopicID]
) ON [PRIMARY]
ALTER TABLE [Topic] WITH NOCHECK ADD
CONSTRAINT [PK_Topic] PRIMARY KEY CLUSTERED
(
[TopicID]
) ON [PRIMARY]
ALTER TABLE [Topic] WITH NOCHECK ADD
CONSTRAINT [PK_Topic] PRIMARY KEY CLUSTERED
(
[TopicID] DESC
) ON [PRIMARY] go
drop table topic