| | |
SQL RENAME TABLE Command
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.
RENAME TABLE student TO student_new
This sql command will
rename the student table to student_new
| |
|
|
|
|
|
