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 collection.

• 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
  The DROP PARTITIONING clause changes a partitioned table to a nonpartitioned table.

 

Parent topic:

Partitioned tables

 

Related reference

ALTER TABLE
SQL reference