RENAME statement in sql helps us to rename the table.
Suppose we have a table whose name needs to be changed to a more appropriate and meaningful one. We can do it with RENAME statement.
Syntax of RENAME Table
RENAME TABLE current_table_name TO new_table_name;
Example on RENAME Table
RENAME TABLE tih_Courses TO tutorialsInHand_Courses;
On executing above query successfully, the name of the tih_Courses table will be changed to tutorialsInHand_Courses.