Oracle 9i Tutorial : Adding Comments to Table

Adding a Comment to a Table

You can add a comment of up to 2,000 bytes about a column, table, view, or snapshot by using the COMMENT statement. The comment is stored in the data dictionary and can be viewed in one of the following data dictionary views in the COMMENTS column:
ALL_COL_COMMENTS
USER_COL_COMMENTS
ALL_TAB_COMMENTS
USER_TAB_COMMENTS
Syntax
    COMMENT ON TABLE table | COLUMN table.column
      IS text‘;
In the syntax:
  table  is the name of the table
 
column  is the name of the column in a table
 
text  is the text of the comment
You can drop a comment from the database by setting it to empty string ():
    COMMENT ON TABLE  employees IS ‘;

Leave a Reply