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 : 157
Like every other website we use cookies. By using our site you acknowledge that you have read and understand our Cookie Policy, Privacy Policy, and our Terms of Service. Learn more Got it!