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. |
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.