4. SQL Statements : COMMENT ON
Share this page                  
Valid in: SQL, ESQL
The COMMENT ON statement creates a comment on a table, view, or column.
To display the comments, use the HELP COMMENT statement.
To delete the comments, issue the COMMENT ON statement and specify an empty string (' '). Comments on tables and views are deleted when the table or view is dropped.
To query comments on a certain table, use the iidbms_comment system catalog.
This statement has the following format:
            TABLE [
schema.]name |
            VIEW [schema.]name |
            COLUMN [schema.]table_name.column_name
              IS 'remark_text'
Specifies the name of the object for which the comment is defined.
For COMMENT ON VIEW the name must be the name of a view.
For COMMENT ON TABLE the name can be the name of a table or view.
Defines the text of the comment. The text string must be surrounded by single quotes.
Limits: The maximum length for a comment is 1600 characters.