The Navigator

Previous  Index  Next  How To Use

At the Navigator tab, you can browse the database/schema structure and perform common tasks.

 

The tree-view of the Navigator is made up of the following main nodes:

1.Schema (one or more nodes)

2.Database Objects

3.Security

4.Storage

5.Management & Maintenance

 

If a database engine, like MySQL, doesn't support schema specific security like Roles, the Security node isn't visible.

 

Information is cached in Database Workbench, so adding objects via a script or from another workstation will not reflect in the tree view. Either click the Refresh From Database button in the Database Navigator toolbar, or use the context menu of any object group and select Refresh. This will check if any objects have been removed or added.

 

For information about the icons for each object type, see Object Icons.

 

For detailed information on database engine specific features, see:

Using the Database Navigator with InterBase

Using the Database Navigator with Firebird

Using the Database Navigator with MS SQL Server

Using the Database Navigator with MySQL

Using the Database Navigator with Oracle

Using the Database Navigator with NexusDB

Using the Database Navigator with Sybase Anywhere

Using the Database Navigator with PostgreSQL

 

The Navigator tab has a Filter box, in which you can enter part of an object name, press Enter and it will filter the lists for you, where only objects that partly match are displayed.

 

You can filter on multiple items, by separating with a " ; "-symbol, eg: EMP;CUST will show all with "emp" or "cust" in the name.

 

A filtered Navigator (click to expand)

 

If there are matches, the box turns green, if there are no matches, it turns red. It's yellow while entering new text that hasn't been matched yet.

 

 

 

1. Schema

Each Schema node lists a schema (or database) and its objects. These objects are arranged in groups (folders), like Tables and Indices.

 

Expanding these nodes will list all the objects in the folder. Indices, for example, are also "child" objects of a table (without a table, there's no index) and are listed as a child node with each table as well. Because each index belongs to a table, the table is also accessible from the index node - this creates a recursive tree mechanism.

 

Almost every node (object type) will have a context sensitive menu, as well as the folder nodes (Tables, Procedure etc). You can use these menus to access commonly used functionality.

 

Double clicking a group will open the object editor for the group-object type.

 

You will also notice that for database engines and objects that support user-written descriptions, a "Description" box will be visible after selecting such an object. You can view and modify the description at the bottom of the Navigator and use the Save Description button to save the description to the database. This box will be displayed automatically, which can be turned OFF in the Preferences.

 

Description Box

 

See also: list of available Schema Object Editors

 

 

2. Database Objects

Anything not related to database security, storage or management and is not schema specific is listed under Database Objects. Think of the Microsoft SQL Server 2005 "database triggers" or MySQL "events".

 

See also: list of available Database Objects Editors

 

3. Security

Listed under the Security node is anything related to security that is database specific. This does not include server-wide user accounts, for example. Think of database roles, groups etc.

 

As usual, the object types are put together in groups. Double clicking the group will open the object editor for that particular object type.

 

See also: list of available Security Object Editors

 

4. Storage

Storage lists the data-files used for the connected schema. Any other groups like "shadows" or "transaction logs" are listed here as well. There are currently no context menus available for anything related to storage.

 

See also: list of available Storage Object Editors

 

5. Management & Maintenance

Many different things can be listed under Management & Maintenance - some of which can be found in the Enterprise Manager as well.

 

The actual functionality listed here depends on the type of database engine so better consult the database engine specific topics.

 

Next: The Workspace