SELECT ObjectName=Object_Name(i.object_id),PartitionNum=p.partition_number
,RowNumber=Rows,BoundaryOnRight=Boundary_value_on_right,BoundaryValue=Value
FROM sys.partitions p
Inner Join sys.indexes i ON p.object_id=i.object_id AND p.index_id=i.index_id
Inner Join sys.partition_schemes ps ON ps.data_space_id=i.data_space_id
Inner join sys.partition_functions f ON f.function_id=ps.function_id
Inner join sys.partition_range_values rv ON f.function_id=rv.function_id
AND p.partition_number=rv.boundary_id
转载于:https://blog.51cto.com/sundysang/287882