All Products
Search
Document Center

PolarDB:Rename a partition

Last Updated:May 20, 2024

Each partition has a name. PolarDB for PostgreSQL (Compatible with Oracle) allows you to rename a partition. This topic describes the statement for and provides an example on renaming a partition.

Syntax

ALTER TABLE [ IF EXISTS ] name RENAME TO new_name

Example

ALTER TABLE distributors RENAME TO suppliers;