SqlServer sys.partition_view

--查看partition的四个视图
select * from sys.partition_functions--查看分区函数
select * from sys.partition_parameters
select * from sys.partition_range_values--查看分区函数对应的分区范围
select * from sys.partition_schemes--查看分区架构