你可以删除后alter table 修改一下alter table ta drop CONSTRAINT PK__ta__3BA1BD0A --这个名字可以通过sp_help 'tablename'查到 gocreate CLUSTERED index ta_id_index on ta(id desc) go or create table ta(id int ,col char(1) , CONSTRAINT ta_id_index PRIMARY KEY CLUSTERED (id desc))or create table ta(id int PRIMARY KEY CLUSTERED (id desc) ,col char(1) )
gocreate CLUSTERED index ta_id_index on ta(id desc)
go
or create table ta(id int ,col char(1) ,
CONSTRAINT ta_id_index PRIMARY KEY CLUSTERED (id desc))or
create table ta(id int PRIMARY KEY CLUSTERED (id desc) ,col char(1) )