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.

is_system

1 = Object is used for full-text index fragments.

0 = Object is not used for full-text index fragments.

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

Reference

Partition Function Catalog Views (Transact-SQL)

Catalog Views (Transact-SQL)

sys.partition_range_values (Transact-SQL)

sys.partition_parameters (Transact-SQL)