RENAME TABLE Syntax

11 February 2012 By Praveen Macherla 259 views No Comment
0 Flares Twitter 0 Facebook 0 Google+ 0 0 Flares ×

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;

Tags: ,