Feature
ALL_TAB_COMMENTS displays comments on tables and views accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_TAB_COMMENTS
USER_TAB_COMMENTS
Fields
| Field | 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 comment on the object. |