Export (0) Print
Expand All

sys.partition_functions (Transact-SQL)

Contains a row for each partition function in SQL Server.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Applies to: SQL Server 2012 through SQL Server 2014.

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