Yang, Tong 48706b7552 MRS COMP-LTS 320-lts.1 version

Reviewed-by: Kacur, Michal <michal.kacur@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2024-04-12 12:51:10 +00:00

3.3 KiB

Raw Permalink Blame History

Changing a Table Name

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.

Example

ALTER TABLE table1 RENAME TO table2

Response

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

Parent topic: SparkSQL Schema Evolution and Syntax Description

3.3 KiB Raw Permalink Blame History