Schema Browser

With the Schema Browser you can comfortably navigate through the objects defined in the database. The database objects are always displayed under the currently active Connection. This will be selected either via the Connections View dialog, or will be set automatically upon activation of an SQL Editor or Describe Object dialog.

Schema Browser modes

There are three modes available. Treeview, Category (Accordion) and Tabs. You can switch between the modes by clicking the first icon on Schema Browser toolbar.

When Category mode is activated, all Functions, Packages, Types and Java Sources can be found in section Procedures.

Schema Browser filter

Items can be filtered in all three modes. See the T_ string in Filter field:

If you wish to filter objects by schema, click the icon Schema Filter... on Schema Browser toolbar (the Schema Filter is also accessible from Connections View). Then specify what schemas should be used.

Click the icon Show all Schemas on Schema Browser toolbar to show objects from selected schemas.

Multiple objects selection

It is possible to select multiple objects from the same category and select an action for all selected objects.

Schema Browser features

The Schema Browser also provides the standard functions for each database object (e.g. rename, edit, drop).

When you select a database object, the object properties will be displayed in the Describe Object dialog. If the Describe Object dialog is closed or hidden, click the selected database object to open the dialog.

Tables

Views

Stored Procedures

Procedures, Functions, Packages, Java Sources and Object Types

Sequences

Synonyms

Public and Private Synonyms

Clusters

Database Links

Triggers

The object lists can be filtered by schema and object name. By default, only objects of the user schema are displayed. To filter, use wildcards in object names.

For all database objects you can define bookmarks that are displayed in a separate section. So, you can have a quick access to database objects that are frequently used.