| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.partition_range_values (Transact-SQL) |
sys.partition_range_values (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]
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. |
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)