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

You can modify existing partitions in your database table by using either the Transact-SQL ALTER PARTITION FUNCTION statement or the Manage Partitions Wizard in Management Studio.

To start the Manage Partition Wizard

  • In SQL Server Management Studio, select the database, right-click the table on which you want to create partitions, point to Storage, and then click Manage Partition.

    Note   If Manage Partition is unavailable, you might have selected a table that does not contain partitions. Click Create Partition in the Storage submenu, and use the Create Partition Wizard to create partitions in your table.