title: "sys.partition_range_values (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "sys.partition_range_values"
- "partition_range_values_TSQL"
- "partition_range_values"
- "sys.partition_range_values_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.partition_range_values catalog view" ms.assetid: 9aee483e-61f3-4613-bec6-f084161f45ac caps.latest.revision: 18 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-asdb-asdw-pdw-md]
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)