Firebird Specific Preferences

Option

Description

Default Dialect

The default database dialect to use when creating or registering Firebird databases. See the Firebird documentation for more information on database dialects. Dialect "3" is the standard dialect to use for future features and enhancements.

Default Isolation

The default transaction isolation used in the SQL/Script Editor.

Use a connection per SQL/Script Editor

When starting an SQL/Script Editor, Database Workbench will clone the connection, resulting in a multi-threaded SQL Editor. If this is "OFF", the SQL Editor will use the same connection as all editors in Database Workbench, meaning that you have to wait for statement to be finished before being able to execute another statement.

Note:

•"local" protocol connections cannot be cloned and using these will result in a single-threaded version of Database Workbench.

•because multiple connections can be opened, you cannot create FKs via the SQL/Script Editor if this option is turned ON on Firebird 2.0 and earlier.

Show table name prefix for Indices

The main Indices node in the Database Navigator can show the table name before each index.

Use uppercase identifiers by default

The default setting for using uppercase identifiers, this can be modified on a per registered database basis.

Automatically fetch query plan

Always fetch the "query plan" for a query in the SQL/Script Editor.

Use RECREATE TABLE in scripts

When extracting table DDL, use RECREATE instead of CREATE or ALTER. This can cause tables to be dropped, so be careful.

Map CHAR(16) OCTETS to GUID

When browsing data, CHAR(16) with character set OCTETS will be mapped to a 'global unique identifier' (GUID) data type.

Prohibit using SYSDBA in dialogs

When this option is checked, you cannot use the server wide administrator account to create or register databases, but you can only use specific users instead.

Alternative terminator

An alternative terminator string for separating statements when this is required (eg for a CREATE PROCEDURE statement).