DROP PARTITION
Drops a partition of a partitioned table. If the specified table is not
a partitioned table, an error is returned. If the last remaining partition
of a partitioned table is specified, an error is returned.
- partition-name
- Specifies the name of the partition to drop. The partition-name must identify a data partition that exists in the table.
- DELETE ROWS
- Specifies that any data in the specified partition will be discarded.
All data stored in the partition is dropped from the table without processing
any delete triggers.
- PRESERVE ROWS
- Specifies that any data in the specified partition will be preserved
by moving it to the remaining partitions without processing any delete or
insert triggers. If the specified table is a range partitioned table, PRESERVE
ROWS must not be specified. Dropping a hash partition will require data movement
between the remaining data partitions.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.