Previous
Previous
 
Next
Next

Browsing a Type

To browse a collection type:

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

    Object Browser appears.

  2. From the Object list, select Type.

  3. From the Object Selection pane, select a type.

    The Object Details view appears.

Summary of Available Views

Click the tabs at the top of the page to view different reports. Table: Available Views for Types describes all available views.

Available Views for Types

View Description

Object Details

(Default) Displays details about the selected type. To drop a type, click Drop.

Synonyms

Displays a list of synonyms for the current type.

Grants

Displays a list of grants associated with the type. Grant details include grantee, privilege, and grant options. Actions you can perform include Grant and Revoke.

SQL

Displays the SQL necessary to re-create this type.