List of Tables
The list of tables tree appears on the left side of your Database Explorer main window.
The tree displays all the tables stored in the filelist of the current workspace. The filelist is indicated by the FileListPath value of the workspace description file (.WS). The tree has two root entries: “Tables” and “Tables, opened as”.
The tables list shows all the tables stored in the filelist whose user display name does not start with an @-sign. Tables marked as such are considered hidden/protected and are, by default, not shown in the list of tables. You can change this configuration option. Tables can also be excluded via the “exclude tables” configuration option. When the filelist contains no entries (or when all tables are not listable), an entry is added with the text “empty filelist”.
Navigation
You can click on the 
or 
symbols. If there is a 
, the tree is collapsed, and you can expand the tree by clicking the 
. The 
will change to a 
symbol. Clicking the 
will collapse this branch again. Normally, when you press the asterisk (*) key on the numeric keypad, the complete tree at the current item position is expanded. For Database Explorer, this is only valid for the tree items labeled “indexes”, “Index.n”, and “Columns”. You can click on any treeview item or navigate with the cursor keys through the list of tables, columns, indexes, and segments.
Context Menu
The context menu on the Tables tree branch contains the following choices:
| Option | Action |
|---|---|
| Close All Tables | Closes all opened tables and removes the dataview. |
| Sort the list of Tables | Sorts the treeview based on the current item values in alphabetical order. |
| Find Column by Name | Finds a column by its name. |
| Find Next Column | Finds the next occurrence of the column name. |
| Add Table Numbers | Adds the filelist number to the table entries. |
| Exclude Tables | Opens the dialog to select which tables should be excluded from the list of tables. |
| Change List of Tables Display | Via a popup menu, you can choose between user display name, root name, or logical filename. |
| Expand List of Tables | Expands the treeview node. |
| Collapse List of Tables | Collapses the treeview node. |
The context menu on the Tables, Opened As… contains the following choices:
| Option | Action |
|---|---|
| Add Table via ‘Open As’ | Opens the Open As dialog in which you can select a table to be opened via the open as way. |
| Close All Tables | Closes all opened tables and removes the current dataview. |
| Sort The Tablename Entries | Sorts the treeview based on the current item values in alphabetical order. |
| Find Column by Name | Finds a column by its name. |
| Find Next Column | Finds the next occurrence of the column name. |
| Expand Open As Root Branch | Expands the treeview node. |
| Collapse Open As Root Branch | Collapses the treeview node. |