Retrieving Table Comments

user_tab_comments view has the comments on your tables:


SQL> SELECT *
  2  FROM user_tab_comments
  3  WHERE table_name = 'EMP';

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------
EMP                            TABLE
employee stores the information of employees


SQL>

Home »
Oracle »
Table »

Comment: