Online Documentation for SQL Manager for Oracle

Using Navigation bar and Toolbars

The Navigation bar and Toolbars provide quick access to tools implemented in Visual Database Designer.

 

 

Database

select a database for building the diagram

 

File

create a new diagram;

open an existing diagram;

save the current diagram to a *.pgd file;

save the current diagram as a custom file

 

Navigator

use Diagram Navigator

 

General

cancel latest modification;

repeat canceled modification;

refresh objects in the diagram;

Print setup - define printing settings;

print the diagram;

show Print Preview;

edit diagram options

restore the default size and position of the window

 

Pages

add a new page;

delete the current page;

delete all pages.

 

Database Objects

Contains the list of objects that can be placed to diagram.

 

 

Context menu of Database Objects group allows you to:

search for objects in the diagram using the Database Objects pane;

add objects to the diagram using the Database Objects pane;

Show Tables - отображать на диаграмме таблицы.

Show Views - отображать на диаграмме представления.

As tree/ As list - switch objects view;

Sort by... - enable/disable sorting;

refresh list of objects.

 

The main toolbar (by default, the toolbar is located at the top of the diagram area) contains a number of tools (including items of the Navigation bar, context menu, tools for printing diagram, etc.) allowing you to:

select the database for building the diagram;

create a new diagram;

open an existing diagram;

save the current diagram to a *.pgd file;

save the current diagram as an image;

activate the Incremental search panel;

• adjust diagram zoom for optimal representation: zoom in, zoom out, fit model;

switch cursor mode: select / select rectangle to fit;

open the Print Setup dialog;

print the diagram;

show Print Preview;

arrange objects in the diagram;

extract metadata of all objects in the diagram and load the script to Execute Script Editor;

perform Reverse Engineering;

refresh objects in the diagram;

view/edit diagram options;

• specify a predefined zoom value;

restore the default size and position of the window;

cancel latest modification;

repeat canceled modification.

 

 

Object Customization panel allows you to define font color, pen color and brush color.

 

 

The Pages toolbar (by default, the toolbar is located at the top of the diagram area) contains tools for working with diagram pages allowing you to:

add a new page;

delete the current page;

delete all pages.

 

 

Diagram toolbar located on the left allows you to:

align left edges;

align right edges;

align tops;

align bottom;

align horizontal centers;

align vertical centers;

space equally, horizontal;

space equally, vertical.

 

set the cursor mode to Select;

enables creating tables on clicking;

enables creating views on clicking;

create a new relation; switch to create relation mode;

enables creating comment on clicking.

 

NB: You can enable\disable Toolbars and Navigation bars at Environment Options.

 

---