Partition Information in SQL SERVER

Partition Function Information

The Partition Function Information is obtained from the sys.partition_functions table as shown below

SELECT * FROM SYS.PARTITION_FUNCTIONS

Partition Range Information

The Partition Range information is obtained from the sys.partition_range_values as shown below

SELECT * FROM SYS.PARTITION_RANGE_VALUES

Partition Scheme Information

The Partition Scheme information is obtained from the sys.partition_scheme as shown below

SELECT * FROM SYS.PARTITION_SCHEME

Partitions Information

The Partition information can be obtained from the sys.partitions table as shown below.

SELECT * FROM SYS.PARTITIONS