SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-17
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.
28 DATE_DISPLAY_FORMAT VARCHAR(64) Reserved for future use
29
CASE_SENSITIVE_COMPARI
SON
CHAR(2) Case-sensitive comparison, if
character type column.
Y case-sensitive
N case-insensitive
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