ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 403
SQL Statements A - D
DROP PARTITION
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;