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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft