Note
This view is available starting with V2.2.30.
Purpose
The view displays the comments of all tables and views in the current tenant.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the table or view. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table or view. |
| TABLE_TYPE | VARCHAR2(11) | NO | The type of the object. |
| COMMENTS | VARCHAR2(4000) | NO | The comments of the object. |
Sample query
Query the comment information of the STUDENT table in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_TAB_COMMENTS WHERE TABLE_NAME='STUDENT';
The return result is as follows:
+-------+------------+------------+---------------------------+
| OWNER | TABLE_NAME | TABLE_TYPE | COMMENTS |
+-------+------------+------------+---------------------------+
| SYS | STUDENT | TABLE | student information table |
+-------+------------+------------+---------------------------+
1 row in set
References
To view the comments of all tables and views accessible to the current user: ALL_TAB_COMMENTS
To view the comments of all tables and views owned by the current user: USER_TAB_COMMENTS
For more information about how to add comments to a table, see Add comments to schema and non-schema objects.