HP 3000 Manuals

ALLBASE/SQL Reference Manual

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; 

MPE/iX 5.5 Documentation