Log in to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click View in the left-side navigation pane to get a list of views in the current database.
In the view 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. You can also double-click the name of the target view to go to the view management page, which includes the Attribute and Data tabs.
Structure tree
You can click the expand icon before the name of the target view in the view list, and the structure tree of the view is displayed in a drop-down list, as shown in the following figure. The structure tree of a view 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
The names of view objects support ascending example by head character by default in the view list. 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 |
|---|---|
| Check View Properties | Click this option to go to the Attribute tab, where you can view comprehensive information such as the basic information, columns, and code of the view. |
| Check View Data | Click this option to go to the Data tab, to check data in the view. |
| Export | Click this option to export objects. The current object is exported by default. For more information, see Export schemas and data. |
| Download | Download the SQL file for the view object. |
| Copy | Click this option to copy the object name, SELECT statement, INSERT statement, UPDATE statement, or DELETE statement. |
| Delete | Click this option to delete the current view object. |
Attribute and data tabs
Attribute tab:
Basic Info: displays information such as View Name, Check Item, and Created By.
Column: displays information of the base table corresponding to the view, such as Field Name, Data Type, and Comment.
Code : displays the definition script of the view.
Data tab: displays the columns that the view contains. The navigation bar provides the following buttons for you:
ButtonDescriptionDownload Data You can export the query results to a CSV, SQL, or Excel file. Back to Start Click this button to jump to the first page. Previous Click this button to go to the previous page. Next Click this button to go to the next page. Jump to Bottom Click this button to jump to the last page. Display Data Volume Click this button to set the maximum number of rows to be displayed on a page. Search Enter a keyword in the search box to search for the view data. Columns Click this button to select the columns to be displayed on the page. Column Mode Click this button to display the data in the selected rows in the form of a table. On the Column Mode page, you can switch to the previous or next row. The column mode makes it easier to view data in a row that has many columns. Refresh Click this button to refresh the data in the table.