DROP PARTITION

Scope

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

Example

   CREATE PARTITION PartsPart WITH ID = 10;

   ALTER TABLE PurchDB.Parts SET PARTITION PartsPart;

   ALTER TABLE PurchDB.Parts SET PARTITION NONE;

   DROP PARTITION PartsPart;