Export (0) Print
Expand All

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.

user_type_id

int

ID of the type. Is unique within the database. For system data types, user_type_id = system_type_id.

In SQL Server 2005 and later versions, 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft