当前位置: 首页 > 工具软件 > Comment.js > 使用案例 >

COMMENT Command

芮瑾瑜
2023-12-01

The COMMENT command allows you to add clarifying (semantic) explanations about tables and table columns to the data dictionary. Figure 7-20 shows the syntax diagram for this command.


Listing 7-19. Adding Comments to Columns and Tables
SQL> comment on table salgrades
2 is 'Salary grades and net bonuses';
Comment created.
SQL> comment on column employees.comm
2 is 'For sales reps only';
Comment created.
SQL> select comments
2 from user_tab_comments
3 where table_name = 'SALGRADES';
COMMENTS
-------------------------------------------
Salary grades and net bonuses
SQL> select comments
2 from user_col_comments
3 where table_name = 'EMPLOYEES'
4 and column_name = 'COMM';
COMMENTS
-------------------------------------------
For sales reps only


 类似资料:

相关阅读

相关文章

相关问答