If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the creation label of the table, view, snapshot, or column.
TABLE
specifies the schema and name of the table, view, or snapshot to be commented.
COLUMN
specifies the name of the column of a table, view, or snapshot to be commented.
If you omit schema, Oracle7 assumes the table, view, or snapshot is in your own schema.
IS 'text'
is the text of the comment. See the syntax description of 'text' .
Example
COMMENT ON COLUMN shipping.notes
IS 'Special packing or shipping instructions'
To drop this comment from the database, issue the following statement:
COMMENT ON COLUMN shipping.notes IS ''