Altering Partitioning Table into Regular Table

Description

To alter an existing partitioned table into a regular one, use the ALTER TABLE statement.

Syntax

ALTER {TABLE | CLASS} <table_name>

REMOVE PARTITIONING

Example

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

ALTER TABLE nation2 REMOVE PARTITIONING;