Online Documentation for SQL Manager for SQL server

Creating/editing partition scheme

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



Enter a name for the new partition scheme, or modify the name of the partition scheme being edited.


Partition function

Use the drop-down list to select the name of the partition function that will use the partition scheme.


Partition Scheme Editor - Editing partition scheme definition




Partitions created by the partition function are mapped to the filegroups specified in the partition scheme.

Select the filegroup name in the Filegroup drop-down list for each of the intervals specified by the partition function. If PRIMARY is selected, the partition is stored in the primary filegroup.


Hint: Filegroups can be created on the Filegroups page of the Database Properties dialog.