Partition Schemes Wizard (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Wizards

The Partition Scheme Wizard builds and submits a CREATE PARTITION SCHEME statement, letting you specify a partition function and a file group mapping. Once created, the partition scheme can be referenced when creating a partitioned table or index.

Note: Before creating a partition scheme, consult Microsoft SQL Server documentation for detailed information on topics such as the relationship between the partition function and filegroups specified. For more information, see Accessing Third Party Documentation.

To create a new partition wizard using a wizard:

  1. Open a creation wizard for a partition scheme. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

For related information, see the following topics:

Partition Schemes (SQL Server) - Properties

When creating or editing a partition scheme, this tab/panel lets you work with the following settings:

Setting Description


Provide a name for the partition scheme.

Partition Function

Select the partition function that specifies the range, input parameter type, and boundary values for this partition scheme.

Filegroup Name

Lets you specify the names of the filegroups to store the partitions specified by the selected Partition Function. Consult Microsoft SQL Server documentation for details on the relation ship between filegroups and partitions. For more information, see Accessing Third Party Documentation. Use the New, Delete, Up, and Down buttons to create and maintain the value list.