The Database Object Tree offers a similar functionality as the Database Object Explorer but can be displayed alongside the SQL editor tabs. The DB Object tree offers a subset of the features the DbExplorer offers. The Database Object Tree can be displayed using → .
The DB Object tree always uses a separate connection regardless of the configuration of the current connection profile.
The elements of each part of the tree are only loaded when the node is expanded for the first time.
The quick filter above the object tree can be used to quickly search for objects with a specific name. The filtering will only be done on already loaded elements of the tree.
The behavior of the quick filter is the same as the filter in the DbExplorer
In general, dropping an element into the editor, will insert the element's name into the editor. There are however two exceptions to this rule:
SELECTstatement for the table will be inserted
To display the data of a table, drag the table node from the Database Object Tree to the result panel of the
current SQL editor. SQL Workbench/J will then generate an appropriate
for the table and execute it immediately.
When the object tree is displayed, the context menu of the editor contains a new item. This will try to find and select the identifier at the cursor location in the Object Tree.
If the schema (or catalog) that contains the object has not yet been loaded, it will be loaded in order to be able to display the current identifier.