Partition Functions Wizard (SQL Server)

Go Up to Microsoft SQL Server Object Wizards

The Partition Functions Wizard lets you build and submit a CREATE PARTITION FUNCTION statement, specifying a range, input parameter type, and boundary values. Once created, the partition function can be referenced by the partition scheme used to create a partitioned table or index.

Note: Before creating a partition function, consult Microsoft SQL Server documentation for detailed information on topics such as type restrictions and boundary value usage. For more information, see Accessing Third Party Documentation.

To create a new partition function using a wizard:

1. Open a creation wizard for a partition function. 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:
   • Properties panel - for details, see Partition Functions (SQL Server) - Properties.
   • DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
3. Finally, use the Execute button to create the object.

For related information, see the following topics:

• Partition Schemes Wizard (SQL Server)
• Indexes Wizard (SQL Server)
• Tables Wizard (SQL Server)

Partition Functions (SQL Server) - Properties

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

Setting	Description
Name	Provide a name for the partition function.
Input Parameter Type	Select the data type of the column used for partitioning.
Range	Select to which side of each functional value interval (LEFT, RIGHT) the functional value belongs, when interval values are sorted in ascending order from left to right.
Function Values	Lets you specify the boundary values to include as FOR VALUES arguments to the CREATE PARTITION FUNCTION statement. Each boundary value is a constant expression that can reference variables. The set of values provided define the partition points for an index or table partitioned using this function. Use the New, Delete, Up, and Down buttons to create and maintain the value list.