SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-280
Manage Partitions of Hash Partitioned Tables and
Indexes
Manage Partitions of Hash Partitioned Tables and Indexes
Use MODIFY to manage hash partitions of SQL/MX tables and indexes. You can drop
only the last partition. You must manage tables and indexes separately regardless of
whether they are related.
The form of MODIFY for hash partitioned tables and indexes is:
MODIFY {TABLE | INDEX} [[catalog.]schema.]object
{drop | move | add}
drop is:
DROP [PARTITION] WHERE partition-identification
[RECLAIM | NO RECLAIM]
[with-shared-access]
move is:
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition
[NAME new-partition-name]
[partition-size]
[RECLAIM | NO RECLAIM]
[with-shared-access]
add is:
ADD [PARTITION] [TO] LOCATION new-partition
[NAME new-partition-name]
[partition-size]
[RECLAIM | NO RECLAIM]
[with-shared-access]
partition-identification is:
LOCATION [\node.]$volume[.subvolume.file-name]
| NAME partition-name
| {FIRST | LAST} PARTITION
| [KEY=] VALUE(partition-number)