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 object may store a comment for it.
Comments are for information only and do not affect data retrieval or manipulation in any way.
Comments may be read with the
DESCRIBEcommand, see DESCRIBE, or by retrieving the appropriate columns from the
INFORMATION_SCHEMAviews, see the Mimer SQL Reference Manual.
Store the comment 'Holds currency details' on the CURRENCIES table:COMMENT ON TABLE currencies IS 'Holds currency details';
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40