Knowledgebase Home / How to Drop a Database Table in phpMyAdmin

How to Drop a Database Table in phpMyAdmin


In this article, we will show you how to delete database tables using phpMyAdmin.

phpMyAdmin is a free and opensource application for MySQL database management. It is one of the most popular web-based MySQL management tools for web hosting services.  Written in PHP, phpMyAdmin gives users the ability to interact with their MySQL databases.

Note: Deleting or dropping tables from a  database will permanently remove all the data stored in that  table. Make sure to check if you need the data for any applications/websites before dropping the table.

Quick Steps

  1. Login to cPanel and open up phpMyAdmin.
  2. Select the database that contains the table you wish to drop from the list shown in the left hand column.
  3. Locate the table you want to drop from the list shown in the right hand panel and click on Drop to delete the table.
  4. You will receive a warning popup. Click on OK to drop the table.

Dropping a Database Table

Go to cPanel > Databases and open phpMyAdmin.

cPanel Main Page

cPanel Main Page

Once you are in the phpMyAdmin tool, Select the database that contains the table you wish to drop from the list shown in the left hand column.

Databases in phpMyAdmin

Databases in phpMyAdmin

After selecting the database, locate the table you want to drop from the list shown in the right hand panel and click on Drop to delete the table.

Database Tables in phpMyAdmin

Database Tables in phpMyAdmin

phpMyAdmin will ask you to confirm the deletion request. Click on OK to delete the table.

Deletion Confirmation Box

Deletion Confirmation Box

Note: Foreign key checks specifies whether or not to check foreign key constraints for InnoDB tables.

The table has been deleted from the database, including everything that used to be in it.

Conclusion

Congrats! Now you know how to drop a database table using phpMyAdmin.

We'd love to hear your thoughts. How can we make this better?


If the steps above listed in this article do not resolve your issue, please feel free to open a support ticket and we’d be happy to take a look.

Looking for better web hosting? Sign up today and take 50% off your first month with promo code: 1stmonth50

Our Guiding Principles

  • Provide consistent, stable and reliable web hosting services.
  • Ensure rapid ticket response and quick resolutions to issues.
  • Never saturate or over-provision servers to ensure stability and speed for our customers.
  • Use only high quality enterprise-class hardware to ensure minimal downtime from hardware failures.
  • Provide clear pricing with no hidden fees or gotchas.