All Products
Search
Document Center

ApsaraDB for OceanBase:Rename a column

Last Updated:Jun 03, 2024

This topic describes the supported conversion scope of ALTER TABLE DDL operations for renaming a column during data migration from an Oracle database to an Oracle tenant of OceanBase Database.

Syntax

RENAME COLUMN old_name TO new_name;

Supported operations

Renaming columns is supported. Sample code:

ALTER TABLE T RENAME COLUMN OLD_NAME TO NEW_NAME;