Comments may be stored against any of the following objects:
Comments cannot be deleted - they can only be replaced by a new comment. A blank string may be provided as a comment if you want to suppress an existing comment.
Only the creator of the schema to which the object belongs may store a comment for the object.
Comments are for information only and do not affect data retrieval or manipulation in any way.
Comments may be read with the DESCRIBE command, see DESCRIBE, or by retrieving the appropriate columns from the INFORMATION_SCHEMA views, see the Mimer SQL Reference Manual.
Store the comment 'Holds currency details' on the CURRENCIES table:COMMENT ON TABLE currencies IS 'Holds currency details';
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40