Help Center/ Data Lake Insight/ Delta SQL Syntax Reference/ Delta SQL Syntax Reference/ Schema Evolution Syntax/ RENAME TABLE
Updated on 2025-01-09 GMT+08:00
View PDF
Share

RENAME TABLE

Function

The ALTER TABLE ... RENAME command is used to change the table name.

Syntax

ALTER TABLE tableName RENAME TO newTableName

Parameter Description

Table 1 RENAME parameters

Parameter

Description

tableName

Table name.

newTableName

New table name.

Required Permissions

  • SQL permissions
Table 2 Permissions required for executing ALTER TABLE

Permission Description

ALTER permission on a table
  • Fine-grained permission: dli:table:alter
  • Metadata services provided by LakeFormation. Refer to the LakeFormation documentation for details on permission configuration.

Example

ALTER TABLE table1 RENAME TO table2

Response

You can run the SHOW TABLES command to view the new table name.

Parent topic: Schema Evolution Syntax