Sql2005 基于已存在的表创建分区

先要删除所有索引

create clustered index IX_User_Text_RefTime
on dbo.User_Text(RefTime)
on RefTimePS(RefTime);
go

 

select * from sys.partitions where object_id = object_id('User_Text');
select * from sys.partition_range_values;

转载于:https://www.cnblogs.com/50614090/archive/2010/12/02/1894093.html