Browsing a Type

To browse a collection type:

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

Object Browser appears.
From the Object list, select Types.
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	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.