How do i drop a table in MySQL

[man with no name]

I need to remove my SQL table to free up space. How do i do this and with what tool? Please advise. Thanks

[jbroder]

drop table tablename;

on the command line, after you have logged in to mysql.
[This message has been edited by jbroder (edited 04-11-01@10:03 pm)]

[man with no name]

I need to delete all contents of mysql database so I can get below ,my allocated disk space. I dropped my table but it still says I have 25MB or taken space. How can I remove all this?
------------------

[Terra]

*****WARNING******
This is not recommended for the faint at heart - it's the database equivalent of:[nbsp][nbsp]format c:
*****WARNING******

Try this to nuke all tables:
mysql>drop database [database]
mysql>create database [database]

replace: [database] with the name of the database your willing to blast all tables within into oblivion...

--
Terra
--Always something endearing about those big red shiny buttons shielded by plastic covers--
FutureQuest