Online Documentation for SQL Manager for InterBase/Firebird

Using Navigation bar and Toolbar


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

 

View Editor - Using Navigation bar

 

 

Object

iconDB select a database

iconObjects_View select a view for editing

 

General

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

iconShowSQLHelp show SQL help

iconPrint set printing options to print metadata of the view

iconQuickSave save the object using the Quick Save feature

iconQuickLoad load the object from buffers using the Quick Load feature

iconRefresh refresh the content of the active tab

iconEditorMode toggle Text / Visual editor modes

iconRestoreDefaultSize restore the default size and position of the editor window

iconOptions adjust Visual Mode Editors options

 

Tools

iconTools_DependencyTree view the dependency tree for the view

iconAutograntPrivileges set autogrant privileges for the view

iconGrantsOnObject define grants on the view

iconTools_QB edit the view query using Query Designer

 

Explorer

iconDBExplorer browse the view subobjects using the Explorer tree

 

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:

 

Triggers

iconObjects_AddTrigger add a new trigger

iconObjects_EditTrigger edit selected trigger

iconObjects_DropTrigger drop selected trigger(s)

iconSetTriggerInactive set trigger active/inactive

iconOpenInSeparateEditor open selected trigger in a Trigger Editor

 

Description

iconSaveToFile save object description to file

iconCopyToClipboard copy description to clipboard

 

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 into the view using Import Data Wizard

 

Permissions

iconGrantManager_Grant Grant

iconGrantManager_GrantWithGrantOption Grant with Grant Option

iconGrantManager_Revoke Revoke

iconGrantManager_GrantAll Grant All

iconGrantManager_GrantAllWithGrantOption Grant All with Grant Option

iconGrantManager_RevokeAll Revoke All

iconGrantManager_GrantOnAll Grant on All

iconGrantManager_GrantWithGrantOptionOnAll Grant on All with Grant Option

iconGrantManager_RevokeOnAll Revoke on All

iconAddGranteeObject Add grantee object

 

DDL

iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Execute Script

 

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.