Purpose
The ALL_COL_COMMENTS view displays comments on all the columns of the tables and views accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
USER_COL_COMMENTS
DBA_COL_COMMENTS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| OBJECT_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 on the column. |