SQL RENAME TABLE Command

Switch to full style

Post a reply

DrRakha

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

Post a reply

Related Posts to : SQL RENAME TABLE Command
SQL COPY TABLE Command -
BETWEEN SQL COMMAND -
SQL ALTER Command -
PHP echo command -
Calling the man Command -
SQL GROUP BY Command -
SQL DISTINCT Command -
SQL LOCATE command -
Average SQL command -
SQL COUNT 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