sys.partition_functions (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Contains a row for each partition function in SQL Server.

Column nameData typeDescription
namesysnameName of the partition function. Is unique within the database.
function_idintPartition function ID. Is unique within the database.
typechar(2)Function type.

R = Range
type_descnvarchar(60)Function type.

fanoutintNumber of partitions created by the function.
boundary_value_on_rightbitFor range partitioning.

1 = Boundary value is included in the RIGHT range of the boundary.

0 = LEFT.
is_systemApplies to: SQL Server 2012 through SQL Server 2016.

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

0 = Object is not used for full-text index fragments.
create_datedatetimeDate the function was created.
modify_datedatetimeDate the function was last modified using an ALTER statement.

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

Partition Function Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.partition_range_values (Transact-SQL)
sys.partition_parameters (Transact-SQL)

Community Additions