Modification of existing tables

You can change existing nonpartitioned tables to partitioned tables, change the attributes of existing partitioned tables, or change partitioned table to nonpartitioned tables.

Use the ALTER TABLE statement to make changes to partitioned and nonpartitioned tables.

More details about the ALTER TABLE statement and its clauses are available in the SQL Reference topic.

• From a nonpartitioned table to a partitioned table
  Use the ADD partitioning-clause of the ALTER TABLE statement to change a nonpartitioned table into a partitioned table. Altering an existing table to use partitions is similar to creating a new partitioned table.
• Modification of existing partitioned tables
  You can make several changes to your partitioned table by using the clauses of the ALTER TABLE statement.
• From a partitioned table to a nonpartitioned table
  Use the DROP PARTITIONING clause to change a partitioned table to a nonpartitioned table.