来源:csdn
例:
create table pk_test
(
id int,
num int ,
column1 varchar(10)
constraint pk_pk_test primary key (id)
)
调整主键
declare @pk_name varchar(255)
select @pk_name= name from sysobjects where parent_obj =OBJECT_ID('pk_test')
and xtype ='PK'
alter table pk_test drop constraint @pk_name --删除
alter table pk_test constraint pk_pk_test primary key (id) --重新创建