SQLSERVER 创建分区表

-- 建立分区，

-- 首先在数据库中添加文件组

-- 然后给对应的文件组添加相应的物理文件

-- 接下来 创建分区函数

-- 创建 分区方案

-- 创建 表 应用分区方案

实例1：

create partition function rect_id (int) as range right for values(3,5,7)

create partition scheme rect2 as partition rect_id to ([PRIMARY], [data1], [data2], [data3])

create table t_ceshi 

(

  id int,

  ceshi varchar(50)

)

on rect2(id)

 

insert into t_ceshi values (1,1),(2,1),(3,1),(4,1)

insert into t_ceshi values (5,1),(6,1),(7,1),(8,1)

 

select * from t_ceshi where $partition.rect_id(id) = 1

select * from t_ceshi where $partition.rect_id(id) = 2

select * from t_ceshi where $partition.rect_id(id) = 3

select * from t_ceshi where $partition.rect_id(id) = 4

 

select $partition.rect_id(3)

 

select * from t_ceshi where id = 1

 

 

实例2：

--create partition function pf_datetime201602 (datetime) as range right for values('2016-02-07','2016-02-13','2016-02-19','2016-02-25')

--select * from sys.partition_functions

--create partition scheme ps_datetime201602 as partition pf_datetime201602 to ([PRIMARY], [data1], [data2], [data3], [data4])

--SELECT * FROM sys.partition_schemes