EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Using Navigation bar and Toolbar


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

 

Table Editor - Using Navigation bar

 

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

 

Object

iconDB select a database

iconObjects_Table select a table for editing

 

General

iconProperties view/edit table properties

iconPrint set printing options to print metadata of the table

iconRefresh refresh the content of the active tab

iconOptions adjust Table Editor options

iconRestoreDefaultSize restore the default size and position of the editor window

iconCompile compile the table (if it is being modified)

 

Tools

iconTools_TruncateTable call Truncate Wizard to truncate the table

iconAddRestorePoint add restore point

iconTools_DependencyTree view the dependency tree for the table

 

Explorer

iconDBExplorer 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

iconSaveToFile save object description to file

iconCopyToClipboard copy description to clipboard

 

Fields

iconObjects_AddField add a new field

iconObjects_EditField edit selected field

iconObjects_DropField drop selected field(s)

 

Keys

iconObjects_AddPK add a new primary/unique key

iconObjects_EditPK edit selected primary/unique key

iconObjects_DropPK drop selected primary/unique key

 

Foreign Keys

iconObjects_AddFK add a new foreign key

iconObjects_EditFK edit selected foreign key

iconObjects_DropFK drop selected foreign key(s)

 

Checks

iconObjects_AddCheck add a new check

iconObjects_EditCheck edit selected check

iconObjects_DropCheck drop selected check(s)

 

Indices

iconObjects_AddIndex add a new index

iconObjects_EditIndex edit selected index

iconObjects_DropIndex drop selected index(-es)

 

Triggers

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 table using Export Data Wizard

iconTools_ExportAsSQLScript export data from the table as Execute Script using Export as SQL Script Wizard

iconTools_ImportData import data into the table using Import Data Wizard

 

DDL

iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data

 

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