添加主键

--Add Key

alter table [dbo].[BF2ZFB02]

add IDKeyGUID  uniqueidentifier

 

--Set Key Value

update [BF2ZFB02] set IDKeyGUID =  newid()

 

--Alter Key Not Null

alter table [dbo].[BF2ZFB02]

alter column   IDKeyGUID  uniqueidentifier not null

 

--Alter Key as Primary Key

ALTER TABLE [BF2ZFB02]

ADD CONSTRAINT PK_IDKeyGUID PRIMARY KEY (IDKeyGUID)

posted @ 2015-11-11 10:48  iFreeSoft  阅读(222)  评论(0)  编辑  收藏  举报