Tables View


The Tables View provides a hierarchical outline of a database connection. The following symbols are used to identify several object types:

Symbols


three cans
Single named Connection. The small grayed symbol three small cans indicates that the connection is not established.
can Part of the database connection which is identified as Catalog/Database of the database server.
head Schema/User as defined by the database server.
table symbol Table
table symbol with S System Table
table symbol with A Alias
table symbol with V View
column symbol Table Column, Columns can have extended Symbols :
small n The Column does not allow null values.
small x The Column is part of an Index.
small p The Column is part of a primary key.
small f The Column is part of a foreign key.
column symbol with I Index information
column symbol with gray key Foreign key references
column symbol with red key
Primary key references
Table that the foreign key is referring to
Table that referes to the primary key
blue triangle
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
Open 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.
Commit
Connection/Commit
any
If AutoCommit is not checked, then you have to explicitly use this action to commit the last statements.
Rollback
Connection/Rollback
any
If AutoCommit is not checked, then you have the chance to rollback the last statements.
Close 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
Copy
any
Copies the label of the selected elements to the clipboard.
Delete Delete
table
Executes an appropriate drop statement to delete the table, alias or view.
Make Offline 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 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


house symbol 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


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




© Copyright Uwe Voigt 2002, 2003, All Rights Reserved.