Previous Page
Next Page

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;


Previous Page
Next Page