8. SQL Statements : MODIFY : With Clause Options for Modify : Nopartition | Partition=
 
Share this page                  
Nopartition | Partition=
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.