Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
sys.partition_range_values (Transact-SQL)
Contains a row for each range boundary value of a partition function of type R.
|
Column name
|
Data type
|
Description
|
|---|
|
function_id
|
int
|
ID of the partition function for this range boundary value.
|
|
boundary_id
|
int
|
ID (1-based ordinal) of the boundary value tuple, with left-most boundary starting at an ID of 1.
|
|
parameter_id
|
int
|
ID of the parameter of the function to which this value corresponds. The values in this column correspond with those in the parameter_id column of the sys.partition_parameters catalog view for any particular function_id.
|
|
value
|
sql_variant
|
The actual boundary value.
|
Permissions
See Also