USER_COL_COMMENTS

Purpose

This view displays all column comments of the views and tables owned by the current user.

Columns

Sample query

Query all column comments of the T1 table owned by the current user.

obclient [SYS]> SELECT * FROM SYS.USER_COL_COMMENTS WHERE TABLE_NAME='T1';

The query result is as follows:

+------------+----------------+----------+
| TABLE_NAME | COLUMN_NAME    | COMMENTS |
+------------+----------------+----------+
| T1         | __pk_increment | NULL     |
| T1         | ID1            | score    |
| T1         | ID2            | NULL     |
+------------+----------------+----------+
3 rows in set

References

• Query all column comments of the views and tables accessible to the current user: ALL_COL_COMMENTS

• Query all column comments of the views and tables in the current tenant: DBA_COL_COMMENTS