DROP PARTITION

The DROP PARTITION statement removes the definition of a partition for audit logging purposes.

Scope

ISQL or Application Programs

SQL Syntax

  DROP PARTITION PartitionName

Parameters

PartitionName: specifies the name of the partition to be dropped.

Description

The partition being dropped must not have any tables associated with it. Use the ALTER TABLE SET PARTITION statement to remove any tables associated with it before dropping the partition.
The DEFAULT partition cannot be dropped. It can be reset to NONE or to another partition with the START DBE NEWLOG statement.

Authorization

You must have DBA authority to use this statement.

Example

A partition can be dropped after all tables in it are assigned to PARTITION NONE.

   CREATE PARTITION PartsPart WITH ID = 10;
 
   ALTER TABLE PurchDB.Parts SET PARTITION PartsPart;
 
   ALTER TABLE PurchDB.Parts SET PARTITION NONE;
 
   DROP PARTITION PartsPart;