A table consists of rows and columns. Each column is a field, and its title is the field name. A row of data is a record. A database table contains one or more records. A table without records is an empty table. Each table usually has a primary key that uniquely identifies each record.
In OceanBase Developer Center (ODC), click a connection name to open the connection. In the navigation pane on the left, click the Tables tab to view the list of tables. In the list, double-click a table name to open the table management page. On this page, you can view and modify table data on the Data tab. You can also view properties such as basic information, columns, partitions, indexes, constraints, and DDL on the Properties tab.
Viewing partition information requires the root@sys account. Therefore, you must set the root@sys user in the advanced configuration when you create the connection.
The database version requirements are as follows:
Database | Version |
OceanBase Database Oracle mode | V2.0.0 and later. |
OceanBase Database MySQL mode | V1.4.1 and later. |