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.

Permissions

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