Searching For and Browsing Database Objects

Searching and Filtering Database Objects

To search or filter objects in the Object Selection pane:

1. Navigate to Query Builder:

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

   2. Click Object Browser.

      Object Browser appears.

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

   Only objects in the current schema display. Remember that the values available in the schema depend upon your workspace privileges.

3. Select an object type from the Object list.

   The list of objects that appears depends upon the available objects in the current schema. Note that any object having a red bar adjacent to it is invalid.

4. To search for an object name, enter a case insensitive search term in the search field.

5. To view all objects, leave the search field blank.

Hiding the Object Selection pane

You can hide the Object Selection pane by selecting the Hide Objects control. This control displays on the right side of the Object Selection pane. If the Object Selection pane appears, selecting this control hides it. Similarly, if the Object Selection pane is hidden, selecting this control causes the pane to reappear.

Selecting a Database Object

Once you locate the database object you want to view, simply select it. The selected object displays in the Detail pane. If no object is selected, the Detail pane is blank.