Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

View table comment with Oracle SQL Developer

How can I view table comments in Oracle SQL Developer?


I added some comments:

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

I know I can use some SQL query like SELECT * FROM user_tab_comments; to display the comments, but I am curious with it is possible to view them using Oracle SQL Developer's GUI, as we can do for column comments by opening the "Columns" tab for a given table.

enter image description here

like image 237
Franck Dernoncourt Avatar asked Jul 26 '15 20:07

Franck Dernoncourt


1 Answers

You can view the table comments by going to the "Details" tab and scrolling down:

enter image description here

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

enter image description here

enter image description here

The second solution also allows you to edit the comment.

like image 186
Franck Dernoncourt Avatar answered Jan 01 '23 12:01

Franck Dernoncourt