Online Documentation for SQL Administrator for SQL Server

Properties


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

 

Name

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

 

Parameter

 

Data type

Specifies the data type of the column used for partitioning.

 

Length/precision

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.

 

Partition Function Editor - Properties

 

 

!CheckBox Boundary values belong to left intervals

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 Intervals area and select the Create Add Boundary Value popup menu item.

 

To remove a value, right-click the value within the Intervals area and select the Drop Delete Value popup menu item.

 

Use the MoveUp Move Boundary Value up and the MoveDown Move Boundary Value down popup menu items to reorder the intervals.

 

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

 

To drop the partition scheme which uses the current partition function, right-click within the Intervals area and select Drop Delete Partition Scheme popup menu item.