SQL Server 现有表建立分区表

查看表分区

SELECT o.name objectname,i.name indexname, partition_id, partition_number, [rows]
  FROM sys.partitions p
 INNER JOIN sys.objects o ON o.object_id=p.object_id
 INNER JOIN sys.indexes i ON i.object_id=p.object_id and p.index_id=i.index_id
 WHERE o.name LIKE '%table_name'

创建分区函数，参考例子

CREATE PARTITION FUNCTION PF_name (datetime2(7))
AS RANGE RIGHT FOR VALUES (
'20180601', '20180701','20180801',