MODIFY...PARTITION...TO DROP
The MODIFY...PARTITION...TO DROP statement drops one or more partitions.
All data in the dropped partitions is deleted, even if the table is referenced, and even if deleting the rows will violate foreign key constraints.
This modify operation drops all secondary indexes and rebuilds persistent indexes.
Syntax:
MODIFY tablename PARTITION partition-name [,partition-name] TO DROP
tablename
Specifies a range-partitioned table.
partition_name
Specifies a logical partition name. Partition names in a list must be in a single dimension.
Note: Logical partition names can be found in table iilpartitions.partition_name in iidbdb.
If the partitioning definition is multi-dimensional (that is, defined with subpartitions), you can drop partitions in any dimension. All logical partitions specified, however, must be in a single dimension.
Last modified date: 08/28/2024