HP 3000 Manuals

ALLBASE/Replicate User's Guide

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
       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 the NONE
     partition. 

     CREATE PARTITION PartsPartition WITH ID = 10;

     ALTER TABLE PurchDB.Parts SET PARTITION PartsPartition;

     ALTER TABLE PurchDB.Parts SET PARTITION NONE;

      DROP PARTITION PartsPartition; 

MPE/iX 5.0 Documentation