Renaming Tables

To rename a table, use the RENAME TABLE statement as follows:

• Input

RENAME TABLE customers2 TO customers;

• Analysis

RENAME TABLE does just that, it renames a table. Multiple tables may be renamed in one operation using the syntax:

RENAME TABLE backup_customers TO customers,              backup_vendors TO vendors,              backup_products TO products;