Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.partition_parameters (Transact-SQL)
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric 👁 Image
SQL database 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)
Feedback
Was this page helpful?