Use the alter table command to drop one or more list or range partitions. You cannot use alter table to drop a hash or round-robin partition.
The syntax is:
alter table table_name drop partition partition_name [, partition_name]...
For each partition you drop, Adaptive Server:
Deletes all data on the partition.
Deletes the partition definition from the system catalog.
Drops all corresponding local index partitions that refer to this data partition.
Regenerates the partition condition object of the base table and each local index.
Deletes all statistics information on this partition.
Rebuilds all global indexes.
If you attempt to drop a partition from a table that
is referenced by another table, and the partition to be dropped
and the referencing table are not empty, the command fails because
of possible violations with the foreign-key constraint, and Adaptive
Server displays error message 13971.
