Online Documentation for SQL Manager for SQL server

Creating/editing partition function

Use the Partition Function tab of Partition Function Editor to create/edit a partition function and specify its properties.

Name

Enter a name for the new partition function, or view the name of the partition function being edited.

Parameter

Type

Specifies the data type of the column used for partitioning.

Size

Specifies the size of the data type. This box is not editable if the size of the selected data type is fixed or not applicable.

Scale

Specifies the maximum number of decimal digits that can be stored to the right of the decimal point. This box is editable only for numeric and decimal data types only.

Collation

Defines the collation for text, char, nchar, varchar, nvarchar values.

Boundary values belong to left interval

This option specifies to which side of each boundary value interval, left or right, the boundary value belongs, when interval values are sorted by the Database Engine in ascending order from left to right. If checked, LEFT is specified.

Boundary values

This area lists the boundary values specified by the partition function.

To add a value, right-click within the Boundary values area and select the Add Value popup menu item, or press the corresponding Add value button.

To remove a value, right-click the value within the Boundary values area and select the Delete Value popup menu item, or press the corresponding Delete value button.

Use the Move up and the Move down buttons or popup menu items to reorder the intervals.

To add a partition scheme which will use the current partition function, right-click within the Boundary values area and select the Add Partition Scheme... popup menu item.

To drop the partition scheme which uses the current partition function, right-click within the Boundary values area and select Drop Partition Scheme <partition_scheme_name> popup menu item.