sys.partition_parameters (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 parameter of a partition function.
| Column name | Data type | Description |
|---|---|---|
| function_id | int | ID of the partition function to which this parameter belongs. |
| parameter_id | int | ID of the parameter. Is unique within the partition function, beginning with 1. |
| system_type_id | tinyint | ID of the system type of the parameter. Corresponds to the system_type_id column of the sys.types catalog view. |
| max_length | smallint | Maximum length of the parameter in bytes. |
| precision | tinyint | Precision of the parameter if numeric-based; otherwise, 0. |
| scale | tinyint | Scale of the parameter if numeric-based; otherwise, 0. |
| collation_name | sysname | Name of the collation of the parameter if character-based; otherwise, NULL. |
| user_type_id | int | ID of the type. Is unique within the database. For system data types, user_type_id = system_type_id. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Partition Function Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.partition_functions (Transact-SQL)
sys.partition_range_values (Transact-SQL)