|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)
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:
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.
Each Schema node lists a schema (or database) and its objects. These objects are arranged in groups (folders), like Tables and Indices.
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.
See also: list of available Schema Object Editors
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".
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.
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
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