Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
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.
See Also