SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

C-51

COMMENTS Table

The COMMENTS table is a catalog table that stores comments and help text for

objects defined in the catalog. Each comment or help text line is a row of the table.

Table C-4 describes the contents of the COMMENTS table.

COMMENTS was created in version 1 and no new columns have been added in

subsequent versions. HC was added to the list of values for column OBJTYPE in

version 2; CP was added in version 300.

Guardian names in the COMMENTS table are fully qualified and use uppercase

characters. Names in the OBJSUBNAME column also use uppercase characters.

Table C-4. The COMMENTS Table

Column Name Data Type Description

1 OBJNAME * CHAR(34) Name of object commented on; for a constraint,

name of table with constraint

2 OBJSUBNAME * CHAR(30) Name of column if object type is CL or HC;

name of constraint if object type is CN;

otherwise ""

3 OBJTYPE * CHAR(2) CL if column

CN if constraint

CP if collation

HC if help text for column

IN if index

TA if table

VI if view

4 SEQNUMBER * SMALLINT

UNSIGNED

Line number of portion of this comment

5 COMMENTTEXT VARCHAR(132) Line of comment text

* Indicates primary key