We can rename any table by using RENAME sql command. The data will not be
lost. Only the table name will be changed to new name. Here is the command to
change the name of a table. Here we will change the name of our student table
name to student_new table.
We can also copy data from one table to a new table. Same way we can copy data from one table with WHERE clause to an existing table.