SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-34
ALTER TABLE Statement
Format 2-enabled partition array allows a partition to grow to one terabyte or the
size of a single disk volume, whichever is smaller.
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 more information, see Modifying the partition array on page A-47.
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. You cannot
drop a partition that contains data unless you use the PARTONLY option of
PURGEDATA. For more information on index issues, see PURGEDATA Command
on page P-36.
{[FROM KEY val [UP TO LAST KEY]] } }
{ TO dest-part [ move-spec ] } }
{ [WITH SHARED ACCESS [wsa-spec]] } }
{ }
{TO dest-part [ move-spec ] } }
{ WITH SHARED ACCESS [wsa-spec] } }
[PARTONLY] MOVE { } }
{([FROM FIRST KEY] UP TO KEY val } }
{ TO dest-part [move-spec] } }
{ [WITH SHARED ACCESS [wsa-spec]])} }
{ }
{([FROM FIRST KEY] UP TO KEY val } }
{ TO dest-part [ move-spec ], } }
{ FROM KEY val [UP TO LAST KEY] } }
{ TO dest-part [ move-spec ]) } }
moves a specified portion of the table name to a new or existing partition,
dest-part, that has the attributes described in move-spec.
You can specify dest-part with a Guardian name, a DEFINE equivalent to a
Guardian name, a node name and volume name, or a volume name only.
For more information about types of move and split operations, see the discussion
of performing moves under Considerations—ALTER INDEX on page A-19.
PARTONLY indicates that name is a partitioned table, one partition of which is to be
moved or split. You must include PARTONLY if name is partitioned.
val is a list of comma-separated literals (one for each column in the key) that
specifies a point at which to split the existing partition.