Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 9.0.0 | 

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;