MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: How to delete a table
Posted by: Eric Braswell
Date: February 28, 2005 12:24AM

The syntax is:

DROP TABLE px_topics;

Note 'drop' not 'delete' -- The syntax "DELETE FROM" refers to data, whereas "DROP" refers to schema/structure.

See:
http://dev.mysql.com/doc/mysql/en/drop-table.html

Eric Braswell
Webmaster,
MySQL AB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How to delete a table
zxzcar16
February 27, 2005 08:29AM
Re: How to delete a table
Eric Braswell
February 28, 2005 12:24AM
Re: How to delete a table
Preston McMurry
February 28, 2005 11:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.