All Products
Search

This Product

    PolarDB:REMOVE PARTITIONING

    Document Center

    PolarDB:REMOVE PARTITIONING

    Last Updated:Jan 11, 2024

    This topic describes how to delete the partitions of a partitioned table and change it to a nonpartitioned table without data loss.

    Syntax

    The ALTER TABLE ... REMOVE PARTITIONING statement is used to delete the partitions of a partitioned table and change it to a nonpartitioned table without data loss.
    ALTER TABLE table_name REMOVE PARTITIONING

    Examples

    Delete all partitions in the sales_range_list table:
    ALTER TABLE sales_range_list REMOVE PARTITIONING;