View comment in table using Oracle SQL Developer

How do I view comments on a table in Oracle SQL Developer?


I added some comments:

COMMENT ON TABLE my_table_name IS 'Here are my table comments';

      

I know that I can use some SQL query, for example SELECT * FROM user_tab_comments;

, to display comments, but I am curious that they can be viewed using the Oracle SQL Developer GUI, as we can do for comments in a column by opening Columns for a given tables.

enter image description here

+3


source to share


1 answer


You can view the comments for the table by going to the Details tab and scroll down:

enter image description here

Alternatively, you can right-click the table and select Table> Comment:



enter image description here

enter image description here

The second solution also allows you to edit the comment.

+4


source







All Articles