Other versions are also available for the following:
SQL Server 2008 Books Online (June 2009)
sys.partition_functions (Transact-SQL)
Contains a row for each partition function.
|
Column name
|
Data type
|
Description
|
|---|
|
name
|
sysname
|
Name of the partition function. Is unique within the database.
|
|
function_id
|
int
|
Partition function ID. Is unique within the database.
|
|
type
|
char(2)
|
Function type.
R = Range
|
|
type_desc
|
nvarchar(60)
|
Function type
RANGE
|
|
fanout
|
int
|
Number of partitions created by the function.
|
|
boundary_value_on_right
|
bit
|
For range partitioning.
1 = Boundary value is included in the RIGHT range of the boundary.
0 = LEFT.
|
|
create_date
|
datetime
|
Date the function was created.
|
|
modify_date
|
datetime
|
Date the function was last modified using an ALTER statement.
|
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
See Also