Online Documentation for SQL Manager for SQL server

Using Navigation bar and Toolbar


The Navigation bar and Toolbar provide quick access to tools implemented in Index Editor.

 

Index Editor - Using Navigation bar

 

 

The Navigation bar of Index Editor allows you to:

 

Object

iconDB select a database

iconObjects_Index select an index for editing

 

General

iconCompile compile the index (if it is being created/modified)

iconSaveDescription save the index description (if it has been modified)

iconRefresh refresh the content of the active tab

iconPrint print metadata of the index

iconRestoreDefaultSize restore the default size and position of the editor window

 

Tools

iconTools_RebuildIndex rebuild the index using the ALTER INDEX ... REBUILD statement

iconTools_ReorganizeIndex reorganize the index using the ALTER INDEX ... REORGANIZE statement

iconServices_UpdateStatistics update statistics using the UPDATE STATISTICS statement

iconTools_DependencyTree view the dependency tree for the index

 

Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with the index:

 

Description

iconSaveToFile save object description to file

iconCopyToClipboard copy description to clipboard

 

DDL

iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in SQL Editor

 

 

Items of the Navigation bar are also available on the ToolBar of Index Editor. To enable the toolbar, open the Environment Options dialog, proceed to the Windows section there and select RadioButton Toolbar (if you need the toolbar only) or RadioButton Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.