NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-43
COMMENT Statement
The columns TABLENAME through PICTURETEXT (1 through 17) were created in
version 1. The columns DATETIMESTARTFIELD through HEADINGTEXT (18
through 23) were added in version 2, and the columns CPRULESNAME through
CHARACTERSET (24 through 26) were added in version 300.
The COLUMNS table has a set of column entries for each partition of a partitioned
table.
All CHAR and VARCHAR fields in the COLUMNS table except for HEADING and
HEADINGTEXT use uppercase characters. Guardian names in the table are fully
qualified.
COMMENT Statement
COMMENT is a DDL statement that writes a comment about a collation, column,
constraint, index, table, or view to the catalog. For partitioned objects, COMMENT adds
the comment for each partition. COMMENT can add a new comment or delete, replace,
or add to existing comments.
comment
is the comment, expressed as a string of single-byte or double-byte characters
enclosed in single or double quotation marks. It can be 0 to 132 bytes long.
CLEAR
purges existing comments before adding the new comment.
The other clauses identify the object to which the comment applies.
24 CPRULESNAME CHAR(34) Name of collation associated with
column; "" if none
25 CPARRAYENTRY SMALLINT
SIGNED
Reserved for internal use by Tandem
software
26 CHARACTERSET CHAR(30) Name of the character set associated
with column
{ COLLATION collation }
{ COLUMN column ON { table | view } }
COMMENT ON { CONSTRAINT constraint ON table }
{ INDEX index }
{ TABLE table }
{ VIEW view }
IS comment [ CLEAR ]
Column Name Data Type Description
* Indicates primary key