Option
|
Description
|
Default
|
Show Shortcut Ruler for use with
bookmarks
|
If this option is turned on ,
then the Tables View displays a separate area that manages
Connection bookmars.
|
On
|
Automatically create a bookmark
when opening connections
|
If this is turned on, then a
bookmark is created in the Shortcut Ruler each time a connection is
opened. This option only is enabled if the Shortcut Ruler option
is turned on.
|
On
|
Switch to the basic SQL execute
method
|
If this option is turned on,
then the DbEdit core executes all generated SQL using
textual statements. The default behaviour, if the option is
turned
off, is to use the java.sql.PreparedStatement. It may be useful to
experiment with this option if a generated statement cannot
succesfully be executed while the JDBC driver reports datatype related
errors.
|
Off
|
Always warn before submittion of
the following statements
|
The following
options do affect generated statements. There is no extra warning or
confirmation prompt before executing a statement from a SQL Editor.
|
| SQL INSERT |
If this is turned on, then a
confirmation dialog is displayed when trying to insert a new table row.
|
On
|
| SQL UPDATE |
If this is turned on, then a
confirmation dialog is displayed when trying to update a single value. |
On
|
| SQL DELETE/DROP |
If this is turned on, then a
confirmation dialog is displayed when trying to delete one ore
more rows from a table or to drop a table or view. |
On
|
Show column properties attached
as symbols (needs refresh)
|
The following
options do not only affect the
Tables View, however it is the first place where their state is
visible.
They change the behaviour of the DbEdit core so that the mentioned
database table properties are not retrieved from the JDBC connection.
It
can be useful to turn off one or all of them if
- the specific right to retrieve the information is not
permitted by the database,
- any database platform depending error occurs when expanding
a table element in the Tables View.
If foreign key information is not available because the option to
retrieve them is turned off, then several functions may not perform
correctly. One of them is the Table Editor's feature to edit cells
using a drop down box with the values of the primary key column the
foreign key column refers to.
|
Show primary keys
|
If this option is turned on,
then the primary key information for database tables is retrieved from
the JDBC connection. The Tables View then displays a  on the table column.
|
On
|
Show foreign keys
|
If this option is turned on,
then the foreign key information for database tables is retrieved from
the JDBC connection. The Tables View then displays a  on the table column. |
On
|
Show indexes
|
If this option is turned on,
then the index information for database tables is retrieved from the
JDBC connection. The Tables View then displays a  on the table column. |
On
|
