How to: Start the Create Partition Wizard (SQL Server Management Studio)

You can partition your database table by using the Create Partition Wizard in SQL Server Management Studio.

To start the Create Partition Wizard

  • In Object Explorer, select the database, right-click the table on which you want to create partitions, point to Storage, and then click Create Partition.


If Create Partition is unavailable, the selected table may already be partitioned. Click Manage Partition on the Storage submenu instead, and use the Manage Partition Wizard to modify your existing partitions.