SQL PHP HTML ASP JavaScript articles and free scripts to download
 

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.








Related Tutorial
Copy data to new table
SQL Left Join
Number of Affected rows
SQL Rename table
PHP MySQL functions

RENAME TABLE student TO student_new


This sql command will rename the student table to student_new


Discuss this tutorial at forum

List of SQL Tutorials


Further readings
Creating a new table by using data from one table
Copying data from one table to another table
Updating another table with data from main table
Update SQL commands
Inserting SUM, AVG data from one table column to other using group by command
Create table query with if exists sql with php script
 
Scripts
PHP
JavaScript
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.