Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 | 

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

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

The following is an example of altering the partitioned table of name "nation2" into a regular one.

ALTER TABLE nation2 REMOVE PARTITIONING;