--删除主键
Declare @Pk varChar(100);
Select @Pk=Name from sysobjects where Parent_Obj=OBJECT_ID('tb_name') and xtype='PK';
if @Pk is not null
exec('Alter table tb_name Drop '+ @Pk)
--创建主键
ALTER Table tableName ADD CONSTRAINT pkName PRIMARY KEY (pkfield)