Export (0) Print
Expand All

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.

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Community Additions

ADD
Show:
© 2014 Microsoft