Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databend.com/sql/sql-commands/ddl/table/ddl-rename-table below:

RENAME TABLE | Databend

• SQL Reference
• SQL Commands
• DDL Commands
• Table
• RENAME TABLE

Changes the name of a table.

ALTER TABLE [ IF EXISTS ] <name> RENAME TO <new_table_name>

CREATE TABLE test(a INT);

SHOW TABLES;
+------+
| name |
+------+
| test |
+------+

ALTER TABLE `test` RENAME TO `new_test`;

SHOW TABLES;
+----------+
| name     |
+----------+
| new_test |
+----------+

Yes

FeedBack

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4