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 View Editor.


View Editor - Using Navigation bar


The Navigation bar of View Editor allows you to:



iconDB select a database

iconObjects_View select a view for editing



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

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

iconTools_QB edit the view query using Design Query

iconRefresh refresh the content of the active tab

iconPrint print metadata of the view

iconObjects_CreateProcedure create a procedure based on the view

iconTools_DependencyTree view the dependency tree for the view

iconRestoreDefaultSize restore the default size and position of the editor window


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 view:



iconObjects_AddIndex add a new index

iconObjects_EditIndex edit selected index

iconObjects_DropIndex drop selected index(-es)



iconObjects_AddTrigger add a new trigger

iconObjects_EditTrigger edit selected trigger

iconObjects_DropTrigger drop selected trigger(s)


Data Management

iconCommit commit transaction

iconRollback rollback transaction

iconTools_ExportData export data from the view using Export Data Wizard

iconTools_ExportAsSQLScript export data from the view as SQL script using Export as SQL Script Wizard

iconTools_ImportData import data

iconTools_BulkInsert bulk insert



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 View 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.