|
| |
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
| |
|
| HOME |
| SQL Tutorial List |
| SQL (Home) |
| SQL Commands |
|
|
|
|
|
| Subscribe |
|
Submit your email address and receive
article and product notifications. Your email is safe with us.
|
|
|
|
