Viewing Object Types
The Database Explorer Tree shows the objects in the various databases shown. The following
procedures explain how the Explorer Tree works.
Do one of the following:
Double-click the database name or folder.
Click the plus sign (+) next to the database name or folder.
Highlight the database name or folder, and press Enter or the right arrow key.
Right-click on the database name or folder, then select Expand/Collapse on the shortcut menu.
The following notes apply to the Database Tree:
Expanding the Tables, Views or System Tables folder loads all these object types.
Expanding the Macros, Functions or Procedures folder loads all these object types.
If no objects exist for a given object type, that folder is automatically removed.
When an index node is expanded for a Table, the approximate index cardinality (number
of unique values) appears after the column name(s).
When expanding the Tables node of a database any Global Temp Tables in that database
are listed in blue.
Join Indexes (called Materialized Views or Materialized Query Tables by some vendors)
are only displayed if requested on the DB Tree tab of Options.
Do one of the following:
Double-click the database name or folder.
Click the minus sign (-) next to the database name or folder.
Highlight the database name or folder, and press Enter or the left arrow key.
Right-click on the database name or folder, then select Expand/Collapse on the shortcut menu.