2.4 Searching For and Selecting Database Objects

Search for and select database objects in Object Browser by selecting an object type from the Object list.

To search for a database object in the Object Selection pane:

  1. On the Workspace home page, click SQL Workshop and then Object Browser.

    Object Browser appears.

  2. 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.

    Description of GUID-FE197709-F1B1-4EAE-BA55-51321832F0F2-default.png follows
    Description of the illustration GUID-FE197709-F1B1-4EAE-BA55-51321832F0F2-default.png
  3. To search for an object name, enter a case insensitive search term in the Search field.
  4. To view all objects, leave the search field blank.

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.