COMMENT (Comment)
Function
COMMENT inserts a comment into a table or a column or changes an existing comment.
Privileges
A user can write comments into base tables owned by that user.
Format
COMMENT ON {TABLE [authorization-identifier.]table-identifier
|COLUMN [authorization-identifier.]table-identifier.column-
name}
IS 'character-string'
Operands
Specifies that a comment is to be processed for a base table or column owned by the user.
Specifies TABLE to write a comment into a table; specifies COLUMN to write a comment into a column.
When specifying a public view in table-identifier, in authorization-identifier specify the word PUBLIC, all in uppercase, enclosed in double quotation marks (").
Specifies a comment in a character string. The length of a character string that can be specified is 0 to 255 bytes.
When specifying a national character string literal as a character string, you need not specify 'N'. Hexadecimal character string literals cannot be specified as a comment.
Notes
Examples
COMMENT ON TABLE STOCK IS 'CREATED JULY 1995'
COMMENT ON COLUMN STOCK.PRICE IS 'REVISED JULY 1995'