Total members 11383 |It is currently Thu Nov 27, 2014 11:48 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R

All times are UTC [ DST ]



  SQL RENAME TABLE Command
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

_________________
Please recommend / share my post if you found it helpful.


Author:
Mastermind
User avatar Posts: 2694
Have thanks: 73 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : SQL RENAME TABLE Command
 SQL COPY TABLE Command     -  
 BETWEEN SQL COMMAND     -  
 SQL COUNT Command     -  
 PHP echo command     -  
 Calling the man Command     -  
 SQL LIKE query Command     -  
 SQL ALTER Command     -  
 SQL GROUP BY Command     -  
 SQL DISTINCT Command     -  
 SQL LOCATE command     -  

All times are UTC [ DST ]









Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team