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
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
See Also
Reference
Partition Function Catalog Views (Transact-SQL)