title
sys.partition_parameters (Transact-SQL)
description
sys.partition_parameters (Transact-SQL)
author
rwestMSFT
ms.author
randolphwest
ms.date
03/15/2017
ms.service
sql
ms.subservice
system-objects
ms.topic
reference
ms.custom
f1_keywords
partition_parameters_TSQL
partition_parameters
sys.partition_parameters_TSQL
sys.partition_parameters
helpviewer_keywords
sys.partition_parameters catalog view
dev_langs
monikerRange
>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric || =fabric-sqldb
sys.partition_parameters (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb ]
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 .
[!INCLUDEssCatViewPerm ] For more information, see Metadata Visibility Configuration .
Partition Function Catalog Views (Transact-SQL) Catalog Views (Transact-SQL) sys.partition_functions (Transact-SQL) sys.partition_range_values (Transact-SQL)