Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.