删除索引

drop index [User_Publish_ischeck] ON [dbo].[User_Publish]

 

删除主键

alter table User_Publish  drop constraint PK_User_Publish

 

创建索引

CREATE NONCLUSTERED INDEX [User_Publish_ischeck] ON [dbo].[User_Publish]

(

    [IsCheck] ASC

)

 

--创建非聚集索引

create nonclustered index inx_entry_stock_on entry_stock_d(entry_stock_bi)

 

--主键且非聚集

alter table entry_stock_d add primary key nonclustered--主键且非聚集

(

 entry_stock_bi,aid

}

 

创建唯一非聚集索引

CREATE UNIQUE INDEX AK_UnitMeasure_Name     ON Production.UnitMeasure(Name); GO 创建分区聚集索引

create clustered index PK_User_Publish_RefTime

on User_Publish(RefTime)

on RefTimePS(RefTime);

 

删除约束

alter table [User_Publish] drop constraint DF_User_Publish_IsCheck

 

增加约束

ALTER TABLE User_Publish

ADD CONSTRAINT DF_User_Publish_IsCheck DEFAULT (0)  FOR IsCheck

 

修改列的类型

ALTER TABLE User_Publish ALTER column IsCheck char(1) null