RENAME
Function
The ALTER TABLE ... RENAME command is used to change the table name.
Syntax
ALTER TABLE tableName RENAME TO newTableName
Parameter Description
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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.