sql server 2008 创建分区表的记录,备忘。另外也可以通过图形化界面操作,具体过程略。
1、创建文件组
alter database sezn add filegroup first01
alter database sezn add filegroup first02
alter database sezn add filegroup first03
2、创建保存数据的文件,分别放在不同的文件组里面
alter database sezn add file (name=N'first01',filename=N'C:\work\data\first01.ndf',size=5Mb,filegrowth=5mb)to
filegroup first01
alter database sezn add file (name=N'first02',filename=N'C:\work\data\first02.ndf',size=5Mb,filegrowth=5mb)
to filegroup first02
alter database sezn add file (name=N'first03',filename=N'C:\work\data\first03.ndf',size=5Mb,filegrowth=5mb)
to filegroup first03
3、创建分区函数
create partition function partfunctionSale(datetime)
as range right for values('20180101','20190101')
4、创建分区方案
create partition scheme partschemeSale
as partition partfunctionSale
to (
first01,
first02,
first03)
5、创建表
create table saleInfo(
[id] [varchar] (32) NOT NULL,
[name] [varchar](16) NOT NULL,
[createTime][datetime] NOT NULL
) on partschemeSale([createTime])