SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-33
ALTER TABLE Statement
Authorizing similarity checks (SIMILARITY CHECK ENABLE) on a table whose
version is older than 310 increases the version of the table (and the version of
objects that depend on the table) to 310. Such a table cannot be registered in an
older version catalog or accessed by older versions of the SQL/MP software.
Prohibiting similarity checks (SIMILARITY CHECK DISABLE) on a table that has
version 310 decreases the version of the table (and the version of objects that
depend on the table).
ADD COLUMN col-name data-type [ DEFAULT def
[ NOT NULL ] ] [ HEADING string | NO HEADING ]
adds a column named col-name to table name, including all its partitions, if any.
The data-type and the DEFAULT clause specify the data type and default value
for the new column. For more information about these clauses, see Data Types on
page D-1 and DEFAULT Clause on page D-26.
NOT NULL specifies that the new column cannot contain null values. If you specify
NOT NULL, you must specify the DEFAULT clause also.
The HEADING clause specifies a heading for the new column. For more
information, see HEADING Clause on page H-1.
You cannot add a column to a table with entry-sequenced file organization.
COLUMN col-name { HEADING string | NO HEADING }
specifies a new default heading for the existing column col-name in table name.
For more information, see HEADING Clause on page H-1.
PARTITION ARRAY { STANDARD | EXTENDED | FORMAT2ENABLED}
specifies the type of partition array used for the specified table and all associated
indexes:
An extended partition array supports a larger number of table and index partitions.
It also allows more indexes to be created against the base table. A
EXTENDED specifies the extended partition array available on
versions 320 and later of NonStop SQL/MP
STANDARD specifies the type of array used by default by NonStop
SQL/MP
FORMAT2ENABLED specifies the size of the partition array, and designates
whether the table is Format 1 enabled or Format 2
enabled. STANDARD and EXTENDED designate a
Format 1-enabled table. FORMAT2ENABLED designates
a Format 2-enabled table. Only key sequenced files can
be Format 2 enabled.