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.