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

 

 

The Navigation bar of Table Editor (in the Edit table mode) allows you to:

 

Object

select a database

select a table for editing

 

General

refresh the content of the active tab

define grants on the table

set printing options to print metadata of the table

save the object using the Quick Save feature

load the object from buffers using the Quick Load feature

show SQL help

adjust Table Editor options

restore the default size and position of the editor window

compile the table (if it is being modified)

 

Tools

view the dependency tree for the table

create a view based on the table

create a procedure based on the table

 

Explorer

browse the table 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 table:

 

Description

save object description to file

copy description to clipboard

 

Fields

add a new field

edit selected field

drop selected field(s)

 

Constraints

add a new primary key

edit selected primary key

drop selected primary key

add a new foreign key

edit selected foreign key

drop selected foreign key(s)

add a new check

edit selected check

drop selected check(s)

add a new unique constraint

edit selected unique constraint

drop selected unique constraint(s)

 

Indexes

add a new index

edit selected index

drop selected index(-es)

 

Triggers

add a new trigger

edit selected trigger

drop selected trigger(s)

 

Data Management

commit transaction

rollback transaction

export data from the table using Export Data Wizard

export data from the table as SQL script using Export as SQL Script Wizard

import data into the table using Import Data Wizard

 

Permissions

Grant

Grant with Grant Option

Revoke

Grant All

Grant All with Grant Option

Revoke All

Grant on All

Grant on All with Grant Option

Revoke on All

Add Grantee object

 

DDL

save DDL to file

open DDL in Execute Script

 

Items of the Navigation bar are also available on the ToolBar of Table Editor. 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.