Yang, Tong 3f5759eed2 MRS comp-lts 2.0.38.SP20 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2023-01-19 17:08:45 +00:00

4.3 KiB

Raw Permalink Blame History

ALTER RENAME TABLE

Function

This command is used to rename an existing table.

Syntax

ALTER TABLE oldTableName RENAME TO newTableName

Parameter Description

**Table 1** Parameters
Parameter	Description
oldTableName	Current name of the table
new_table_name	New name of the table

Examples

alter table h0 rename to h0_1;

System Response

The table name is changed. You can run the SHOW TABLES command to display the new table name.

Parent topic: DDL

4.3 KiB Raw Permalink Blame History