DBA_COL_COMMENTS

2025-12-09 07:09:36  Updated

Feature

DBA_COL_COMMENTS displays the comments on all the columns of all tables and views in the database.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.

  • ALL_COL_COMMENTS

  • USER_COL_COMMENTS

Fields

Field 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.

Contact Us