有几个关于分区的问题,希望大家帮忙了 1. 表已经存在,能否再应运分区方案呢,如果可以,这么用? 2. sqlserver里能否直接通过执行Select * into 表 from 表2时,也带上分区方案,如果能这样那是方便不过?
可以 1:刪除普通索引 2:刪除主健索引並轉為分區表 3:再恢復主健索引 4:恢復普通索引
use TEMPDB go create table t(ID int identity,Num int not null constraint PK_T primary key(Num,ID)) create index IX_T_Num on T(Num)
go create partition function F_Partition(int) as range right for values(1,100,1000) go CREATE PARTITION SCHEME? P_schema as partition F_Partition? ALL to ([PRIMARY])
go drop index IX_T_Num on T alter table T drop constraint PK_T with(Move to P_schema(Num))
alter table t alter column ID int? not null
alter table T add constraint PK_T primary key (Num,ID)
select * from T
DROP TABLE T DROP PARTITION SCHEME P_schema DROP partition function? F_Partition
-----------------------------
如果主健只有一列時直接改
? use TEMPDB go create table t(ID int identity constraint PK_T primary key,Num int not null )--只有一個ID create index IX_T_Num on T(Num)
go create partition function F_Partition(int) as range right for values(1,1000) go CREATE PARTITION SCHEME? P_schema as partition F_Partition? ALL to ([PRIMARY])
go drop index IX_T_Num on T alter table T drop constraint PK_T with(Move to P_schema(ID))--這里改為ID
alter table t alter column ID int? not null
alter table T add constraint PK_T primary key (ID)--改為ID
select * from T
DROP TABLE T DROP? PARTITION SCHEME? P_schema DROP partition function? F_Partition-----------------------------------如果是into生成的表,這樣用 use TEMPDB go select * into T from sysobjects
go
create partition function F_Partition(int) as range right for values(1,1000) go CREATE PARTITION SCHEME? P_schema as partition F_Partition? ALL to ([PRIMARY])
go alter table T alter column ID int not null
alter table T add constraint PK_T primary key (ID) on P_schema(ID)
?
select * from T
DROP TABLE T DROP? PARTITION SCHEME? P_schema DROP partition function? F_Partition
http://topic.csdn.net/u/20090803/15/225c1920-e2a0-417a-9bd8-658644b9b96c.html?35493
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/htl258/archive/2009/08/03/4404607.aspx
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|