Manage types
In OceanBase Developer Center (ODC), click a connection name to open the connection. Then, in the navigation pane on the left, click the Types tab to view the type list. The type list shows the type objects that exist in the database for the current connection. You can right-click an object in the list to perform management operations, or double-click a type name to open the type management page.
Structure tree
As shown in the following figure, click the arrow next to a type name in the type list. A drop-down list appears that shows the structure tree of the type. The structure tree of an object type can have up to five levels. You can right-click an item at any level in the structure tree to view the available operations. For more information about the operations, see the Management operations table.
Management operations
By default, type object names in the type list are sorted in ascending order by the first character.
Quick functions
The following functions are available in the upper-right corner of the structure tree:
Operation |
Description |
Create |
Click the Create icon to create a type. |
Filter |
Click the Filter icon to show valid or invalid types. |
Refresh |
After you perform management operations on the current type object, refresh the structure tree to show the latest information. |
Right-click functions
Right-click an item in the structure tree. The context menu that appears provides operations to manage the object. The following table describes the management operations.
Action Key |
Description |
View Type |
Go to the type management page to view the basic information and code of the current type. |
Create Type |
Go to the Create Type page and follow the steps to create a new type. |
Download |
Download the SQL file of the type object. |
Delete |
Delete the current type. |
Refresh |
After you perform management operations on the current type object, refresh the list to show the latest information. |
Type management page
Double-click a type name in the type list to open the type management page. The page has the following two tabs:
Basic Information: Displays information about the type, such as its Name, Owner, Type, Creation Time, and Modification Time.
DDL: Displays the script that defines the type. This tab also provides functions such as Download, Find, Refresh, and Format.