SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-19
COLS Table
Column names that are regular identifiers are stored in uppercase letters. Column
names that are delimited identifiers are stored as is, without surrounding quotation
marks.
All other character columns except DEFAULT_VALUE and HEADING_TEXT store
letters in uppercase.
An IDENTITY column is defined as a part of the DEFAULT clause of column-
definition
. Depending on the type of the IDENTITY column either of the following
two values can be present in the DEFAULT_CLASS column:

IA - Identity Always, system automatically generates the values. User specified
values are not accepted.

ID - Identity by Default, either the system automatically generates the values, or
the user specifies a value.
30 DISPLAY_DATA_TYPE VARCHAR(128) Reserved for future use
31 RESERVED_FILLER_INT INT Reserved for future use
32
RESERVED_FILLER_CHAR
CHAR(20) Reserved for future use
* Indicates primary key
Column Name Data Type Description