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


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.



All Articles