Symbols
|
|
|
Single named
Connection. The small grayed symbol
indicates
that the connection is
not established. |
|
Part of the database connection
which is identified as Catalog/Database of the database server.
|
|
Schema/User as defined by the
database server.
|
|
Table
|
|
System Table
|
|
Alias
|
|
View
|
|
Table Column,
Columns can have extended Symbols :
|
The Column does not allow
null values. |
|
The Column is part of an
Index. |
|
The Column is part of a
primary key. |
|
The Column is part of a
foreign key. |
|
|
Index information
|
|
Foreign key
references
|
|
Primary key
references |
|
Table that the
foreign key is referring to
|
|
Table that referes
to the primary key
|
|
Database elements
whose structure information is offline available are marked with that
symbol.
|
Note: Tree items
of the
type alias, table or view can be opened in the Table Editor by double click.
|
|
Actions
|
|
Icon
|
Text
|
Selection
|
Description
|
|
Connection/Connect |
any
|
Open a new connection to a
database server. |
|
Connection/Reconnect
|
any
|
Close the connection and
immediately reopen it without propagating the close throughout the
workbench (any open Table Editor remains).
|
|
Connection/Configure
|
any
|
Open the Connection
Configuration dialog with the selected connection.
|
|
Connection/Auto Commit
|
any
|
If checked, the connection is in
auto commit mode. This means that any statement, whether it is
generated
or typed into the SQLEditor is immediately committed.
|
|
Connection/Commit
|
any
|
If AutoCommit is not checked,
then you have to explicitly use this action to commit the last
statements.
|
|
Connection/Rollback
|
any
|
If AutoCommit is not checked,
then you have the chance to rollback the last statements. |
|
Connection/Close
|
any
|
Close the currently displayed
connection. |
|
Connection/Add Bookmark
|
any
|
Create a bookmark for the
currently selected connection. The entry Connection/Add Bookmark is only
available if a bookmark for the selected connection has not yet been
created. |
|
Show/Primary Key References
|
table
|
Expand the selected table to
show it's exported key references. These are references to the primary
key of this table.
|
|
Show/Foreign Key References |
table
|
Expand the selected table to
show it's imported key references. These are the foreign key references
to ohers tables primary keys. |
|
Show/Indexes |
table
|
Expand the selected table to
show its indexes.
|
|
Show/Row Count
|
table
|
Show the row count after the
table name.
|
|
Goto Reference
|
foreign key column
|
Select the primary key column
this foreign key refers to in the Tables View.
|
|
Goto Referrer
|
primary key column
|
Select the foreign key column
that refers to this primary key in the Tables View. |
|
Open/Open With TableEditor
|
table, column
|
Open a table editor on the
currently selected table. If one ore more columns of one table
are
selected the statement used to retrieve the data is formed using only
these columns.
|
|
Copy
|
any
|
Copies the label of the selected
elements to the clipboard.
|
|
Delete
|
table
|
Executes an appropriate drop
statement to delete the table, alias or view.
|
|
Make Available Offline
|
container elements
|
Copy the structure of the
selected elements into the cache and make them available even if the
connection is closed. |
|
Remove from Cache
|
container elements
|
Remove the selected elements
from the cache. |
|
Refresh |
any
|
Refresh the currently displayed
connection data. |
|
Compare With/Each Other
|
|
Compare two elements with each
other.
|
|
Properties
|
table
|
Open the table property page.
|
|
ShortCut Bar
|
|
|
Switch to the main
screen. |
|
If there is a
bookmark it can be switched to by selecting its name in the shortcut
bar. Furthermore the bookmark can be removed by right clicking on
it and chosing Remove.
|
|
Filters
|
|
From the view menu
you can select Filter... to
apply specific patterns to element types which will, if they
match, include the elements into or exclude them from the view.
A filter is effective only if it is turned on through the check box.
Filter text patterns are persistent even if there check boxes are not
checked.
|
|