Altering Partitioning Table into Regular Table

Description

To alter an existing partitioned table into a regular one, use the ALTER TABLE statement. Removing partition does not mean that the data of a table will be deleted.

Syntax

ALTER {TABLE | CLASS} <table_name>

REMOVE PARTITIONING

• table_name: Specifies the name of the table to be altered.

Example

The following example shows how to alter the partitioned table of name nation2 into a regular one.

ALTER TABLE nation2 REMOVE PARTITIONING;