Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Commenting Objects


Comments may be stored against any of the following objects:

 COLUMN
 FUNCTION
 MODULE
 SEQUENCE
 TABLE
 DATABANK
 IDENT
 PROCEDURE
 SHADOW
 TRIGGER
 DOMAIN
 INDEX
 SCHEMA
 SYNONYM
 VIEW

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.

Comment Example

Store the comment 'Holds currency details' on the CURRENCIES table:
 COMMENT ON TABLE currencies IS 'Holds currency details';

Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX