title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

f1_keywords

helpviewer_keywords

dev_langs

monikerRange

sys.partition_functions (Transact-SQL)

rwestMSFT

randolphwest

03/14/2017

sql

system-objects

reference

sys.partition_functions_TSQL

partition_functions

sys.partition_functions

partition_functions_TSQL

sys.partition_functions catalog view

TSQL

>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric

sys.partition_functions (Transact-SQL)

Contains a row for each partition function in [!INCLUDEssNoVersion].

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		Applies to: [!INCLUDEssSQL11] and later. 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.

Permissions

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