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. |
See Also
Reference
Partition Function Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.partition_range_values (Transact-SQL)
sys.partition_parameters (Transact-SQL)