/*建立字段*/
alter table Client add Cli_No nvarchar(8) COLLATE Chinese_PRC_CI_AS NULL
alter table Stocks_Ask_Data add Edit_Id int NULL
alter table Stocks_Ask_Data add StkList_ID_Sell nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL
alter table Stocks_Ask_Data add Trans_Fg tinyint NULL DEFAULT 1
/*更新字段值*/
update Product
set Pro_No=Pro_Code
where Pro_No is null
ALTER TABLE Product ALTER COLUMN Pro_No nvarchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL
/*删除唯一索引*/
ALTER TABLE [dbo].[Product]
drop constraint [IX_Product]
/*创建唯一索引*/
ALTER TABLE [dbo].[Product] ADD
CONSTRAINT [IX_Product] UNIQUE NONCLUSTERED
(
[Pro_No]
) ON [PRIMARY]
GO
/*创建一般索引*/
CREATE INDEX [IX_Product_1] ON [dbo].[Product]([Pro_Name]) ON [PRIMARY]
GO
/*由于新建的Cli_No要改为不为空的字段 ,所以先赋值*/
update Client
set Cli_No=Cli_num
where Cli_No is null
/*在使Cli_No变为唯一索引之前,先修改Cli_No字段不为空*/
ALTER TABLE Client ALTER COLUMN Cli_No nvarchar(8) COLLATE Chinese_PRC_CI_AS NOT NULL
ALTER TABLE Client ALTER COLUMN Cli_addr nvarchar(80) COLLATE Chinese_PRC_CI_AS NULL
ALTER TABLE Client ALTER COLUMN Cli_zip nvarchar(6) COLLATE Chinese_PRC_CI_AS NULL
ALTER TABLE Client ALTER COLUMN Cli_lxr nvarchar(8) COLLATE Chinese_PRC_CI_AS NULL
ALTER TABLE Stocks ALTER COLUMN Stock_Admin nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL
/*删除唯一索引*/
ALTER TABLE [dbo].[Client]
drop constraint [IX_Client]
/*创建唯一索引*/
ALTER TABLE [dbo].[Client] ADD
CONSTRAINT [IX_Client] UNIQUE NONCLUSTERED
(
[Cli_No]
) ON [PRIMARY]
GO
/*创建一般索引*/
CREATE INDEX [IX_Client_1] ON [dbo].[Client]([Cli_name]) ON [PRIMARY]
GO
============================================
/*删除主键*/
ALTER TABLE [dbo].[tab]
drop constraint [PK_tab]
/*删除唯一索引*/
ALTER TABLE [dbo].[tab]
drop constraint [IX_tab_1]
/*删除索引*/
drop index [dbo].[tab].[IX_tab]
/*创建主键*/
ALTER TABLE [dbo].[tab] WITH NOCHECK ADD
CONSTRAINT [PK_tab] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
/*创建唯一索引*/
ALTER TABLE [dbo].[tab] ADD
CONSTRAINT [IX_tab_1] UNIQUE NONCLUSTERED
(
[name]
) ON [PRIMARY]
/*创建索引*/
CREATE UNIQUE INDEX [IX_tab] ON [dbo].[tab]([kl]) ON [PRIMARY]
/*建立字段*/
alter table temptable add Cli_No nvarchar(8)