RENAME TABLE Syntax

This statement renames one or more tables.

RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] …

RENAME TABLE emp_table to employee_details;

Leave a Comment