Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 12.5 ALTER TABLE...DROP SUBPARTITION

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

12.5 ALTER TABLE...DROP SUBPARTITION

Use the ALTER TABLEDROP SUBPARTITION command to delete a subpartition and the data stored in that subpartition. The syntax is:

      ALTER TABLE table_name DROP SUBPARTITION subpartition_name;

Description

The ALTER TABLE… DROP SUBPARTITION deletes a subpartition and the data contained within that partition. To use the DROP SUBPARTITION clause, you must be the table owner, or have superuser or administrative privileges.

Parameters

table_name

The name (optionally schema-qualified) of the modified table.

subpartition_name

The name of the subpartition to be deleted.

Example

The following example deletes the subpartition, sales from the employees table:

      ALTER TABLE employees DROP SUBPARTITION salesman;

Previous PageTable Of ContentsNext Page