Log on to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click Table in the left-side navigation pane to get a list of tables.
The table list displays the table objects in the current database. In the table list, you can view the structure tree of an object. You can also right-click the target object to perform some management actions on the object.
Structure tree
You can click the expand icon before the name of the target table in the table list, and the structure tree of the table is displayed in a drop-down list, as shown in the following figure. The structure tree of a table can have up to three levels. When you right-click an item in the tree, the shortcut menu displays some actions that you can perform on the item. For more information about these actions, see the Management actions section, where you can find the table describing the management options.
Management actions
Right-click the target object in the structure tree. A shortcut menu appears, displaying some management options provided by ODC for you to conveniently manage the target object.
The following table describes the management options.
Option | Description |
View Table Structure | Click this option to go to the Attribute tab, where you can view comprehensive information such as the basic information, columns, indexes, constraints, and DDL statements of the table. |
View Table Data | Click this option to go to the Data tab to view the data in the table. |
Create Table | Click this option to go to the table creation page, where you can create a table as prompted. |
Mock Data | Click this option to mock data to the table. For more information, see Data mocking. |
Single Table Import | Click this option to import data to the table. |
Single Table Export | Click this option to export data from the table. |
Open SQL Console | Click this option to open a new SQL window. |
View DDL | Click this option to go to the Attribute tab to view the SQL statements that define the table. |
Delete | Click this option to delete the table. |
Rename | Click this option to rename the table. |
Refresh | Click this option to refresh the structure tree after you perform management actions on the table, so that the structure tree displays the latest information. |
View Column/View Index/View Constraint | Click these options to go to the Attribute tab to view specific information about the columns, indexes, or constraints in the table. |
Create Column/Create Index/Create Constraint | Click these options to create a column, an index, or a constraint. |
Delete Column/Delete Index/Delete Constraint | Click these options to delete a column, an index, or a constraint. |
Edit Column/Edit Index/Edit Constraint | Click these options to modify the information of a column, an index, or a constraint. |