Database Navigator & Server Manager

Previous  Index  Next  How To Use

This panel lets you edit your Database Navigator and Server Manager settings - descriptions can be found below the screen shot.


Database Navigator and Server Manager Settings (click to expand)



Use secure "Drop Database" confirmation

Use "secure drop" dialog when dropping a database

Autoexpand/collapse tree

Turn on/off the single click tree behaviour as found in the Windows Explorer. Default: ON

Use multi-line tabs

If you un-tick this box, additional tabs will appear next to the Server Manager and a drop down button and left/right arrows will appears. Default: ON

Database Navigator

Autoexpand columns for tables, views and ref constraints

Turn on/off the behaviour in the tree related to expanding (and fetching) columns for objects that have them. Default: ON

Seperate constraint nodes

By default, constraints are grouped in 3 or 4 different tree nodes - Check, Referential, Unique and Primary Key constraints. Uncheck this box to list them all in a single node. Default: ON

Show system generated index names for constraints

Show the system generated index name behind the constraint name. Default: ON

Show indexed columns in indices

By default, the field names of indexed fields are shown behind the index name. Default: ON

Show datatypes for domains/columns

By default, the datatype of a column is shown behind the column name. Columns also show the domain name. Default: ON

Show procedure/function parameters

By default, the Database Navigator shows (part of) the procedure/function parameters, once fetched, behind the procedure/function name. Default: ON

Show horizontal scrollbar

Shows a scrollbar for the navigator tree.

Auto show/hide object description

If an object description is supported, a box with this description will be shown at the bottom of the Database Navigator. Default: ON

Auto scroll on focus

Automatically scroll the focused node into view. Default: ON

Order by Primary Key on Quick Browse

This wil order the data in the "Data" tab of the Table Editor by the table primary key. If you use the Quick Browse function in the Database Navigator, it will use the table primary key to order the data as well. Default: ON

Default action for doubleclick on tables/views

What happens if you double click tables or views. Default: Edit.

Server Manager

Don't re-expand tree upon application start

When expanding "server" nodes, Database Workbench sometimes has to connect to the server to fetch certain information. When working in other environments (for example, out of the office), such connections cannot be established, resulting in delays during application startup. Checking this option avoids re-expanding the Enterprise Manager tree. Default: OFF