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 ' ';