How to drop (delete) a table

A statement that drops a table

      DROP TABLE customers;

A statement that drops a table if it exists

      DROP TABLE IF EXISTS customers;

A statement that empties a table

Use the TRUNCATE TABLE statement to empty a table of all of its records but retain the table structure.

      TRUNCATE TABLE customers;

    Description
      You can use the DROP TABLE statement to delete a table.
If you drop a table, MySQL deletes its definition (including its indexes) and its data.

    

    Warning
       You should never drop a table in a production database without first consulting the DBA, but you probably won’t have the privileges for doing that.

Back