Dropping Range Partitioning

Description

You can drop a partition by using the DROP PARTITION clause of the ALTER statement.

Syntax

ALTER {TABLE | CLASS} <table_name>

DROP PARTITION <partition_name>

Example

The following example shows how to drop the before_2000 partition in the participant2 table.

ALTER TABLE participant2 DROP PARTITION before_2000;

Caution