Find Partition Range in a SQL Server 2005/2008 PartitionTable

In one of the previous articles, we saw how to Find Partition Information in a SQL Server Table. This blog post shows you how to find Partition Ranges for a PartitionFunction. Here’s the query that lists down the partition range values for the partition function ‘TransactionRangePF1’

SELECT psch.name as PartitionScheme,
prng.value AS ParitionValue,
prng.boundary_id AS BoundaryID
FROM sys.partition_functions AS pfun
INNER JOIN sys.partition_schemes psch ON pfun.function_id = psch.function_id
INNER JOIN sys.partition_range_values prng ON prng.function_id=pfun.function_id
WHERE pfun.name = 'TransactionRangePF1'

OUTPUT