How to delete MySQL database tables using phpMyAdmin

This article describes how to delete (drop) a table in a MySQL database using phpMyAdmin.

Be careful! When you delete a database table, all of the data in it is deleted permanently as well. Make sure you have a current database backup before deleting tables.
The following procedure demonstrates how to delete a table in a database. If you want to delete an entire database on our managed hosting plans, you cannot use phpMyAdmin. Use the MySQL Databases tool in cPanel instead.

Deleting a table using phpMyAdmin

To delete a table in a MySQL database using phpMyAdmin, follow these steps:

  1. Log in to cPanel.
    If you do not know how to log in to your cPanel account, please see this article.
  2. Open phpMyAdmin:
    • If you are using the Jupiter theme, on the Tools page, in the Databases section, click phpMyAdmin:

      cPanel - Databases - phpMyAdmin icon

    • If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click phpMyAdmin:

      phyMyAdmin

  3. The phpMyAdmin administration page appears in a new window. In the left pane, click the name of the database that contains the table you want to delete. For example, the following image shows the example_wordpress database selected:

    phpMyAdmin - left pane

  4. In the right pane, select the check box for the table that you want to delete:

    phpMyAdmin - main pane

  5. In the With selected list box, select Drop.

    Alternatively, if you want to keep the table, but delete all of the data that it contains instead, select Empty.
  6. To disable foreign key checks, clear the Enable foreign key checks check box.

    The foreign key check is a useful way to help prevent accidental data deletion. Only disable the foreign key check if you are sure of the effects of doing so. 
  7. phpMyAdmin confirms that you want to delete the table. Click Yes.

More Information

For more information about phpMyAdmin, please visit https://www.phpmyadmin.net.

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.