SELECT *
FROM SYS.PARTITION_RANGE_VALUES prv
left join SYS.PARTITION_SCHEMES ps on ps.function_id = prv.function_id
left join SYS.DATA_SPACES ds on ds.data_space_id = ps.data_space_id
SELECT * FROM sys.partitions
WHERE [object_id] = object_id('Sales') --If there are indexes on the table, each index will be one row in the partitions table
SELECT * FROM sys.partition_functions
SELECT * FROM sys.partition_schemes
SELECT * FROM sys.partition_range_values
No comments:
Post a Comment