sqlservice 表分区方法

--创建分区函数
CREATE PARTITION FUNCTION test_partfunc (int)
AS RANGE RIGHT
FOR VALUES (5000, 10000)
--创建分区架构
CREATE PARTITION SCHEME customer_partscheme
AS PARTITION test_partfunc
TO (fg1, fg2,fg3)
--对一个表进行分区
CREATE TABLE testt (Firstid int, Lastid int, Customerid int)
ON customer_partscheme (Firstid)