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:



iconDB select a database

iconObjects_Index select an index for editing



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



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:



iconSaveToFile save object description to file

iconCopyToClipboard copy description to clipboard



iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data



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.