Rename a column

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. Example:

ALTER TABLE T RENAME COLUMN OLD_NAME TO NEW_NAME;