Add and read comments to tables and columns in ORACLE

Add and read comments to tables and columns in ORACLE

Add and read comments to tables and columns in ORACLE
1. Add a comment to the table: SQL> comment on table name is 'table comment ";

2. Add a comment to the column: SQL> comment on column table. The column is 'column annotation ';

3. read Table comments: SQL> select * from user_tab_comments where comments is not null;

4. Read the column comment: SQL> select * from user_col_commnents where comments is not null and table_name = 'table name ';

The structure of USER_TAB_COMMENTS and user_col_comments in the appendix:

1. user_tab_comments consists of three parts: table_name, table_type, and comments.

2. user_col_comments consists of three parts: table_name, column_name, and comments.

3. display the table structure in SQL * PLUS: desc table name;