|
|
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 VIEWComments 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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se |
|
|