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.

Community Additions

ADD
Show:
© 2014 Microsoft