USER_COL_COMMENTS

Purpose

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

Columns

Sample query

Query the comments of all columns in 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 the comments of all columns in all views and tables accessible to the current user: ALL_COL_COMMENTS

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