RENAME TABLE
This statement renames an existing table to a new name.
Synopsis
- RenameTableStmt
- TableToTable
RenameTableStmt ::=
'RENAME' 'TABLE' TableToTable ( ',' TableToTable )*
TableToTable ::=
TableName 'TO' TableName
Examples
mysql> CREATE TABLE t1 (a int);
Query OK, 0 rows affected (0.12 sec)
mysql> SHOW TABLES;
+----------------+
| Tables_in_test |
+----------------+
| t1 |
+----------------+
1 row in set (0.00 sec)
mysql> RENAME TABLE t1 TO t2;
Query OK, 0 rows affected (0.08 sec)
mysql> SHOW TABLES;
+----------------+
| Tables_in_test |
+----------------+
| t2 |
+----------------+
1 row in set (0.00 sec)
MySQL compatibility
This statement is understood to be fully compatible with MySQL. Any compatibility differences should be reported via an issue on GitHub.
See also
Was this page helpful?