tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER TABLEALTER TABLE ... RENAME COLUMN

ALTER TABLE ... RENAME COLUMN

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:17:13

Description

Supported engine: SparkSQL
Applicable table: External and native Iceberg tables
Purpose: Change field name.

Statement

ALTER TABLE table_identifier 
RENAME COLUMN old_column_name TO new_column_name

Parameter

table_identifier: Data table name
old_column_name: Field name to be changed
new_column_name: Field name after the change

Example

alter table iceberg_rename rename column id to id_2



Previous Topic: ALTER TABLE DROP PARTITION FIELDNext Topic: ALTER TABLE SET TBLPROPERTIES

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback

Search
    Enter keywords to search documentation