This topic describes how to delete partitions and subpartitions and the data stored in these partitions and subpartitions.
Syntax
The ALTER TABLE…DROP PARTITION statement is used to delete partitions and subpartitions and the data stored in these partitions and subpartitions.
ALTER TABLE table_name DROP PARTITION partition_names;
Note This statement cannot delete only a subpartition or delete a hash or key partition.
Parameters
Parameter | Description |
table_name | The name (optionally schema-qualified) of the partitioned table. |
partition_names | The name of the partition. |
Examples
Delete the
p_2014
partition in the sales_range_range
partitioned table:ALTER TABLE sales_range_range DROP PARTITION p_2014;