Using the Object Selection Pane

Searching and Filtering Objects

Use the Object Selection pane to search for and view tables, views, and materialized views within the current schema.

To search or filter objects:

1. Navigate to Query Builder:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Query Builder.

      Query Builder appears.

2. Select a schema from the Schema list on the right side of the page.

   Only objects in the current schema display. Note that the values available in the Schema list depend upon your resource privileges.

3. In the search field at the top of the pane, enter a case insensitive query.

4. To view all tables or views within the currently selected schema, leave the search field blank.

Hiding the Object Selection Pane

You can hide the Object Selection pane by selecting the Hide Table or Views control. By hiding the Object Selection pane, you can increase the size of the Design and Result panes.

The Hide Table or Views control displays on the right side of the Object Selection pane. If the Object list appears, selecting this control hides it. Similarly, if the Object list is hidden, selecting this control causes the pane to reappear.