Rename a column

This article introduces the range of supported conversions for modifying column names using ALTER TABLE DDL when migrating data from an Oracle database to OceanBase Database's Oracle compatible mode.

Syntax

RENAME COLUMN old_name TO new_name;

Supported operations

Renaming columns is supported. Example:

ALTER TABLE T RENAME COLUMN OLD_NAME TO NEW_NAME;