Overview
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. In this section, 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.
Action | Description |
View Table Schema | Click this option to go to the Attribute tab. On this tab, you can view comprehensive information of the table such as the basic information, columns, indexes, constraints, and DDL statements. |
View DDL | Click this option to go to the Attribute tab to view the SQL statements that define 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. |
Import | Click this option to import data to the table. For more information, see Single table export and import. |
Export | Click this option to export data from the table. For more information, see Single table export and import. |
Download | Download the SQL file for the table object. |
Mock Data | Click this option to go to the Mock Data panel. |
Open SQL Window | Click this option to open a new SQL window. |
Copy | Click this option to copy the table name, SELECT statement, INSERT statement, UPDATE statement, or DELETE statement. |
Rename | Click this option to rename the table. |
Delete | Click this option to delete 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. |