Note
This view is available starting with V2.2.30.
Purpose
This view displays the comments of all columns in all views and tables of the current tenant.
Applicability
This view is applicable only to OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the object. |
| COLUMN_NAME | VARCHAR2(128) | NO | The name of the column. |
| COMMENTS | VARCHAR2(4000) | YES | The comment of the column. |
Sample query
Query all column comments of the T1 table.
obclient [SYS]> SELECT * FROM SYS.DBA_COL_COMMENTS WHERE TABLE_NAME='T1';
The query result is as follows:
+-------+------------+----------------+----------+
| OWNER | TABLE_NAME | COLUMN_NAME | COMMENTS |
+-------+------------+----------------+----------+
| SYS | T1 | __pk_increment | NULL |
| SYS | T1 | ID1 | score |
| SYS | T1 | ID2 | NULL |
+-------+------------+----------------+----------+
3 rows in set
References
Query all column comments of all views and tables accessible to the current user: ALL_COL_COMMENTS
Query all column comments of all views and tables owned by the current user: USER_COL_COMMENTS