title: "sys.partition_functions (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/14/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_functions_TSQL"
- "partition_functions"
- "sys.partition_functions"
- "partition_functions_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.partition_functions catalog view" ms.assetid: 96515727-728b-4bea-804a-36ce915b8b75 caps.latest.revision: 37 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 partition function in [!INCLUDEssNoVersion].
| Column name | Data type | Description |
|---|---|---|
| name | sysname | Name of the partition function. Is unique within the database. |
| function_id | int | Partition function ID. Is unique within the database. |
| type | char(2) | Function type. R = Range |
| type_desc | nvarchar(60) | Function type. RANGE |
| fanout | int | Number of partitions created by the function. |
| boundary_value_on_right | bit | For range partitioning. 1 = Boundary value is included in the RIGHT range of the boundary. 0 = LEFT. |
| is_system | Applies to: [!INCLUDEssSQL11] through [!INCLUDEssCurrent]. 1 = Object is used for full-text index fragments. 0 = Object is not used for full-text index fragments. |
|
| create_date | datetime | Date the function was created. |
| modify_date | datetime | Date the function was last modified using an ALTER statement. |
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_range_values (Transact-SQL)
sys.partition_parameters (Transact-SQL)