SQL Table

SQL Rename Table

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.

Please Share this page
Views : 34