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.
You can view the table comments by going to the "Details" tab and scrolling down:
Alternatively, you can right-click on the table, and select Table > Comment:
The second solution also allows you to edit the comment.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With