Tables Branch

Names Displayed

By default, the user-display name of each table in the file list is shown in the list. The list itself is a "treeview," which makes navigation easier. You can change the name to be displayed from user-display name to root name or logical name via the configuration panel or a right mouse click.

Display Table Numbers

It is possible to display the numbers of the tables at the left or the right side of the table name. If you want to sort the tree entries based on table number, you want them on the left side. If you want to see the table numbers but do not want to be bothered by the table numbers, you want the numbers on the right side. To sort correctly, it is necessary that all table numbers have the same length. This can be configured by using prefix zeroes.

Clicking in the Treeview

When you click with the mouse cursor on a table item or on a particular index item, the attached table will be opened in the data view, and a previous table will be closed. Via the configuration dialog, you can tell Database Explorer to automatically expand that tree node.

When you click on individual columns in the “Columns” branch of the treeview, you will see the picture change to indicate that you have selected/deselected that column. Selecting columns enables the option to rebuild the data view based on selected columns.

Clicking on a particular index node will change the current sort order to that index. When the data view contains a grid, the sort order change will be immediately seen. When the data view contains just one record, the option DDOOrderingIsGridOrdering tells Database Explorer what to do when finding records.

Use Cursor Keys

When you use the cursor keys to navigate through the list of tables, and you wait while the current tree item is a table or index-specific item for more than the time defined in the configuration panel, you will see the table being opened. This behavior is consistent with Windows Explorer.

Close All Tables?

When you click on the first entry in the list of tables while a table is open, you can close the table. The option to confirm is configurable in the configuration dialog.

Indexes and Fields

In front of each table name (by default, the user-display name in the file list), you will find at startup a sign. When you click on this, the chosen branch expands and shows the “Indexes,” “Columns,” “Parent tables,” and “Child tables” branches, each with the in front of it.

By default, a Windows treeview will show a tooltip hint when the label is too long to display within the treeview width. You can tell Database Explorer via the configuration panel if the tooltips should be used or not. Toggling this option becomes effective at the next run.

The context menu contains the following choices:

Option	Action
Open	Open the table that is currently selected, used when it was open before and closed or when you navigated with the cursor keys and disabled the tree timer.
Close	Closes the current table and removes the data view.
Open In New dbExplorer Window	Open this table via a new instance of Database Explorer.
Erase All Data	Start a zero-file operation. Function can be disabled by configuration and/or database administrator permissions.
Find Column by Name	Find a column by its name.
Find Next Column	Find the next occurrence of the column name.
Remove Table MRU Data	If you configured Database Explorer to store the Most Recently Used data (tables, workspaces, and/or selected column information), you can use this option to clear the stored information for the currently selected table.
Expand Table Entry	Expand the treeview node.
Collapse Table Entry	Collapse the treeview node.