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. |
Permissions
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.