I just need to know how to delete a table. Not its contents I know how to use the query DELETE FROM but how do I do the DROP TABLE one? the table name is "Events" Thank YOU!
[RESOLVED] DROP TABLE proper syntax please
mySQL Manual wrote:DROP [TEMPORARY] TABLE [IF EXISTS]
tbl_name [, tbl_name] ...
[RESTRICT | CASCADE]
~Brett
What you are wanting to do is impossible.
I just need to know how to delete a table. Not its contents
A table can not be dropped without the content going along with it.
DROP TABLE removes one or more tables. You must have the DROP privilege for each table. All table data and the table definition are removed, so be careful with this statement!
From MySQL site.
Even if this were possible, how would the content that belongs in a table ever be queried. If you really need the content of the table then export that table to your local hard drive or wherever you want to put it, then DROP the table. The closest thing you could get to dropping a table and saving its content on the database would be to rename it, but I really don't know why you would want to do this in the first place?
Houdini wrote:What you are wanting to do is impossible.
I am just merley stating I want to know how to drop a table I allready know how to drop the contents and yes I realize that dropping a table consists of deleteing its contents as well thats plain elementary. I figured it out anways thanks