Online Documentation for SQL Administrator for SQL Server

Partition Schemes


The Partition Schemes section of the Database Explorer is used for managing partition schemes in the selected database.

 

Use the context menu to:

Create create a new partition scheme

Edit edit the selected partition scheme(s)

Drop drop selected partition scheme(s)

  • rename the selected partition scheme
  • create the object copy on the same server
  • clone the object copy to another server

Print create and print the report

 

Partition Schemes

 

 

The list displays the existing database partition schemes as a grid with the following columns: Name, Partition Function, Description. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.

 

To open a Partition Scheme in the Partition Scheme Editor, double-click it in the grid. Alternatively, you can right-click the partition scheme alias and select the Edit Partition Scheme(s) context menu item.