SQL RENAME TABLE Command

DrRakha
Posts: 2715
Joined: Tue Mar 27, 2007 10:55 pm
Location: Earth
Website

Tue Jul 17, 2012 11:16 pm

To rename a table you can use the RENAME command, table's data will no be lost. Follow this query :

Code:: RENAME TABLE department TO department_new

In this query you rename table department to table department_new

Related Posts to : SQL RENAME TABLE Command
SQL COPY TABLE Command -
BETWEEN SQL COMMAND -
SQL LOCATE command -
Average SQL command -
JVM does not recognize MQ command. -
SQL COUNT Command -
SQL LIKE query Command -
SQL ALTER Command -
PHP echo command -
Calling the man Command -

Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com