sys.partition_functions (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Contains a row for each partition function in SQL Server.
| 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: SQL Server 2012 (11.x) and later. 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. |
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
See Also
Partition Function Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.partition_range_values (Transact-SQL)
sys.partition_parameters (Transact-SQL)