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 Query Data.

 

Database

select a database for the query

 

General

toggle AutoDDL

execute the current query

execute selected code only

execute code under cursor

prepare query for execution

view estimated query execution plan

run Query Designer to design the query as a diagram

configure Query Data within the Tools | Query Data page of the Environment Options dialog

switch the results representation mode: on Edit tab or on separate tab

show SQL help

create a view based on the query

create a procedure based on the query

restore the default size and position of the editor window

 

Queries

add a new query (note that the current query text will not be lost)

rename the current query

remove the query

remove all queries from the editor

edit the query text using Favorites editor and add the query to the Favorite Queries list

 

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

 

Edit

activate the Find Text dialog

load a query from an *.sql file using the Open SQL File dialog

save the query to an *.sql file

save all queries to an *.sql file

 

Logs

activate the Find Text dialog

save the query log to a file

clear logs

 

Data Management

commit transaction

rollback transaction

export the returned dataset using Export Data Wizard

export the returned dataset as SQL Script using the Export as SQL Script wizard

import data

 

 

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

 

---