DBA_COL_COMMENTS

2024-04-19 08:42:49  Updated

Purpose

The DBA_COL_COMMENTS view 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 the MySQL mode.

  • ALL_COL_COMMENTS

  • USER_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.

Contact Us