sys.partition_parameters (Transact-SQL)

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.

See Also