1. Knowledge Base
  2. >
  3. Results
  4. >
  5. How To Drop Tables From a Database in phpMyAdmin

How To Drop Tables From a Database in phpMyAdmin

This article will demonstrate how to drop (permanently delete) tables from a database in phpMyAdmin. This will delete the table and everything in it.

It is recommended that you make a backup before you perform any destructive actions, such as dropping database tables. Without a backup, there will be no way to restore anything mistakenly deleted.

WARNING!  Dropping tables in your database permanently deletes the table and all the data stored in that table. Make sure that none of your applications or websites rely on the information contained in the table(s) you are deleting.

To drop an entire table from your database:

  1. Log in to your cPanel or Plesk.
  2. Navigate to your control panel and click the phpMyAdmin icon.

    Plesk:
    Plesk phpMyAdmin

    cPanel:
    cPanel phpMyAdmin

  3. In the phpMyAdmin homepage, select the database you wish to work with from the list of databases on the left column.

    Select Database

  4. A list of tables will appear in the left column and the wider right column.

    phpMyAdmin - List of Tables

  5. Put a checkmark on the table(s) you wish to drop (permanently delete).
  6. Navigate to the dropdown box at the bottom that initially says "With selected."
  7. Select Drop from the list if you wish the table completely gone. If you want to clear the data in the table and keep its structure, select Empty.

    With Select - Drop

  8. It will ask you if you really want to drop the table(s). Check to make sure you selected the tables you really want to delete.
  9. Click on Yes to drop (delete) the table.

Alternatively, you can click the Drop (or Empty) icon alongside the selected tables.

phpMyAdmin - Empty

The phpMyAdmin will prompt you to confirm the deletion. Confirm to proceed.

At this point, the table has been dropped from the database, including its data.