---

{ “title”: “ALTER TABLE RENAME”, “language”: “en”, “description”: “This statement is used to rename certain names of existing table properties. This operation is synchronous,” }

Description

This statement is used to rename certain names of existing table properties. This operation is synchronous, and the return of the command indicates the completion of the execution.

grammar:

ALTER TABLE [database.]table alter_clause;

The alter_clause of rename supports modification of the following names

1. Modify the table name

grammar:

RENAME new_table_name;

2. Modify the rollup index name

grammar:

RENAME ROLLUP old_rollup_name new_rollup_name;

3. Modify the partition name

grammar:

RENAME PARTITION old_partition_name new_partition_name;

4. Modify the column name

:::tip Tips This feature is supported since the Apache Doris 1.2 version :::

Modify the column name

grammar:

RENAME COLUMN old_column_name new_column_name;

Notice:

• When creating a table, you need to set ‘light_schema_change=true’ in the property.

Example

1. Modify the table named table1 to table2

ALTER TABLE table1 RENAME table2;

2. Modify the rollup index named rollup1 in the table example_table to rollup2

ALTER TABLE example_table RENAME ROLLUP rollup1 rollup2;

3. Modify the partition named p1 in the table example_table to p2

ALTER TABLE example_table RENAME PARTITION p1 p2;

4. Modify the column named c1 in the table example_table to c2

ALTER TABLE example_table RENAME COLUMN c1 c2;

Keywords

ALTER, TABLE, RENAME, ALTER TABLE

Best Practice