SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-77
Syntax Description of CREATE TABLE
column is an SQL identifier. column must be unique among column names in the
table. If the name is an SQL/MX reserved word, you must delimit it by enclosing it
in double quotes. Such delimited parts are case-sensitive. For example: "join".
column cannot be SYSKEY if the clustering key contains SYSKEY.
data-type is the data type of the values that can be stored in column. A default
value must be of the same type as the column, including the character set for a
character column. See Data Types on page 6-16.
DEFAULT default | NO DEFAULT
specifies a default value for the column or specifies that the column does not have
a default value. See DEFAULT Clause on page 7-2.
HEADING 'heading-string'| NO HEADING
specifies a string heading-string of 0 to 128 characters to use as a heading for
the column if it is displayed with a SELECT statement in MXCI. The heading can
contain characters only from the ISO88591 character set. The default heading is
the column name. If you specify a heading that is identical to the column name,
INVOKE and SHOWDDL do not display that heading.
If you specify NO HEADING or HEADING ‘’, NonStop SQL/MX stores this as
HEADING ‘’, and the column name is displayed as the heading in a SELECT
statement. The behavior for HEADING ‘’ is different from that of NonStop SQL/MP,
which does not display anything for a heading in a SELECT statement if the
heading is specified as HEADING ‘’.
CONSTRAINT constraint
specifies a name for the column or table constraint. constraint must have the
same catalog and schema as table and must be unique among constraint names
in its schema. If you omit the catalog portion or the catalog and schema portions of
the name you specify in constraint, NonStop SQL/MX expands the constraint
name by using the catalog and schema for table. See Database Object Names
on page 6-12.
If you do not specify a constraint name, NonStop SQL/MX constructs an SQL
identifier as the name for the constraint in the catalog and schema for table.The
identifier consists of the fully qualified table name concatenated with a system-
generated unique identifier. For example, a constraint on table A.B.C might be
assigned a name such as A.B.C_123..._01... . Use the SHOWDDL statement to
display this generated constraint name. See SHOWDDL Command on page 4-67.
NOT NULL [[NOT] DROPPABLE]
is a column constraint that specifies that the column cannot contain nulls. If you
omit NOT NULL, nulls are allowed in the column. If you specify both NOT NULL
and NO DEFAULT, each row inserted in the table must include a value for the
column. See MXCI Parameters on page 6-73 and Null on page 6-76.