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;
|
