Drop or delete a table in MySQL

To remove a table from a MySQL database, and remove all of its data, use the following SQL command.

The command will conditionally delete a table if it exists. The ‘if exists’ syntax is optional, but is useful when using SQL commands in a file, such as when importing data, as it will not display errors.

drop table if exists recipes;

The command can be issued from any SQL source including an application with database connectivity (i.e., PHP, Java, etc.) or directly from mysql command (see Connect to a MySQL server using the mysql command for more information).

 

About Quinn McHenry

Quinn was one of the original co-founders of Tech-Recipes. He is currently crafting iOS applications as a senior developer at Small Planet Digital in Brooklyn, New York.
View more articles by Quinn McHenry

The Conversation

Follow the reactions below and share your own thoughts.

3 Responses to “Drop or delete a table in MySQL”

  1. February 26, 2009 at 4:16 pm, amit said:

    good its useful

    Reply

    • August 07, 2010 at 3:59 pm, Sanjuraut said:

      hi…
      its nice..

      Reply

  2. July 02, 2010 at 8:18 pm, Novalidemail said:

    “The command will conditionally delete a table if it exists.”
    Conditionally?? Could you ‘esplain that a little better?

    Reply

Leave a Reply