sys.partition_range_values (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Contains a row for each range boundary value of a partition function of type R.

Column nameData typeDescription
function_idintID of the partition function for this range boundary value.
boundary_idintID (1-based ordinal) of the boundary value tuple, with left-most boundary starting at an ID of 1.
parameter_idintID 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.
valuesql_variantThe actual boundary value.

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Partition Function Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.partition_functions (Transact-SQL)
sys.partition_parameters (Transact-SQL)

Community Additions