sys.partition_parameters (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

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.


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been 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)