NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-31
ALTER TABLE Statement
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. See Data Types
on page D-1 and DEFAULT Clause on
page D-24 if you need details about these clauses.
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. See HEADING
Clause on page H-1 for more information.
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.
(See HEADING Clause on page H-1 for more information.)
PARTITION ARRAY { STANDARD | EXTENDED }
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.
PARTITION ARRAY applies to partitions created later for a table, even if the table
is not currently partitioned. Altering the base table causes all associated indexes to
be altered automatically to the value specified for the base table.
You can use the PARTITION ARRAY clause in SQLCI or in dynamic SQL
statements. To check its value, use the FILEINFO DETAIL command.
For additional information, see Modifying the partition array
on page A-42.
DROP PARTITION part-name
specifies the name of an empty partition to drop from a table. part-name cannot
be the primary partition. you cannot drop a partition that contains data. If you want
EXTENDED specifies the extended partition array available on versions 320 and later
of NonStop SQL/MP
STANDAR
D
specifies the type of array used by default by NonStop SQL/MP