The PARTITION= clause allows the partitioning scheme of a table to be changed. The table does not have to be partitioned initially. The NOPARTITION clause removes partitioning from a table. For the syntax of a PARTITION= specification, see Partitioning Schemes (see Partitioning Schemes).

The with_clause options PARTITION= or NOPARTITION are permitted in a MODIFY statement only if the MODIFY statement specifies a storage structure which includes the RECONSTRUCT action. Other forms of the MODIFY statement (for example, MODIFY TO TRUNCATED) do not allow either PARTITION= or NOPARTITION clauses.

The default for the MODIFY statement is to not change the partitioning scheme of a table.