Name
COMMENT
Synopsis
COMMENT ON
{TABLE [schema.]{ table_name | view | snapshot}
| COLUMN [schema.]{ table_name | view | snapshot}.column
}
IS 'text'Adds a comment about a table, view, snapshot, or column into the data dictionary.
Keywords
- TABLE
Specifies that the comment be associated with a table, view, or snapshot.
- view
Name of a view with which the comment will be associated.
- snapshot
Name of a snapshot with which the comment will be associated.
- COLUMN
Specifies that the comment be associated with a column.
- text
Actual text of the comment. This text will be recorded in the data dictionary.
Common keywords and clauses: schema, table_name.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
