Tutorials

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