DROP TABLE tablename;
ALTER TABLE tablename RENAME newname;

http://www.mysql.com/doc/en/ALTER_TABLE.html
http://www.mysql.com/doc/en/DROP_TABLE.html

Regards,
Mike Hillyer
www.vbmysql.com


> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, June 18, 2003 10:13 AM
> To: [EMAIL PROTECTED]
> Subject: DELETE or RENAME tables?
> 
> 
> How do you DELETE or RENAME a table?
> 
> Thanks.
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?> [EMAIL PROTECTED]
> 
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to