Partition Schemes

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

http://www.sqlservercentral.com/articles/partition/64740/#