Online Documentation for SQL Manager for SQL server

Managing indices


The Indices tab is provided for managing table indexes. Double-click an index to open Index Editor for editing the index.

 

Right-click an index to display the context menu allowing you to create new, edit, drop, enable/disable the selected index, or enable/disable all indexes. Using the menu you can also export the list of the table indexes to any of supported formats.

 

Indexes management tools are also available through the Navigation bar of Table Editor.

 

Table Editor - Managing indexes

 

 

The Indexes list provides the following attributes of each index of the table:

Index Name

Columns

Clustered

Primary Key

Unique

Disabled

 

For details see Indexes.

 

If necessary, you can also use the Index Description area to supply a description for each index.