How to get table comments and column comments by Oracle

This article mainly introduces Oracle how to get table comments and column comments, the article is very detailed, has a certain reference value, interested friends must read it!

All tables

Select table_name from user_tables; / / tables owned by the current user select table_name from all_tables; / / tables for all users select table_name from dba_tables; / / including system tables

Comments on the tabl

Select * from user_tab_comments; / / the current user has comments on tables select * from dba_tab_comments; / / comments on all user tables select * from all_tab_comments; / / comments on all user tables dba_tab_comments, all_tab_comments has one more ower column than user_tab_comments

Comments for the column

Select * from user_col_comments;select * from dba_col_comments;select * from all_col_comments

Accordingly, there is dba_col_comments,all_col_comments, which have more ower columns than user_col_comments.

The above is all the content of the article "how to get table comments and column comments from Oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!