General

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

Tree colors

The colors used for the background, text and additional text (like index names in the Database Navigator).

Database Navigator

Autoexpand fields

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

Autoexpend for tables, views and ref constraints

Automatically expand the Columns node for these objects.

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 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.

Enterprise 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