This topic describes commands for partitioned tables.

Classification Command for partitioned tables Description
Creation CREATE TABLE... PARTITION BY Creates a partitioned table.
CREATE TABLE ... PARTITION BY HASH Creates a hash partitioned table for which the number of partitions is specified.
Change ALTER TABLE...ADD PARTITION Adds a partition to an existing partitioned table.
ALTER TABLE...ADD SUBPARTITION Adds a subpartition to an existing subpartitioned partition.
ALTER TABLE...EXCHANGE PARTITION Swaps an existing table with a partition or a subpartition.
ALTER TABLE...MOVE PARTITION Moves a partition or a subpartition to a different tablespace.
ALTER TABLE...RENAME PARTITION Renames a table partition.
ALTER TABLE...SPLIT PARTITION Divides a partition into two partitions and redistributes the content of the partition between the new partitions.
ALTER TABLE...SPLIT SUBPARTITION Divides a subpartition into two subpartitions and redistributes the content of the subpartition between the new subpartitions.
ALTER TABLE…MERGE PARTITION Merges two partitions into a new partition that has the content of the original two partitions.
ALTER TABLE...MERGE SUBPARTITION Merges two subpartitions into a new subpartition that has the content of the two original two subpartitions.
Deletion ALTER TABLE... DROP PARTITION Deletes a partition structure and the data that is stored in the partition.
ALTER TABLE... DROP SUBPARTITION Deletes a subpartition structure and the data that is stored in the subpartition.
ALTER TABLE...TRUNCATE PARTITION Removes the data from a specified partition but leaves the partition structure intact.
ALTER TABLE...TRUNCATE SUBPARTITION Removes all the data from a specified subpartition but leaves the subpartition structure intact.
DROP TABLE Deletes a schema and the data that is stored in the table.
TRUNCATE TABLE Removes all the data from a table and retains the schema.
Query Query a specified partition Queries a specified partition or subpartition.