Manage views

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 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.

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.