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
- Login to cPanel and open up phpMyAdmin.
- Select the database that contains the table you wish to drop from the list shown in the left hand column.
- Locate the table you want to drop from the list shown in the right hand panel and click on Drop to delete the table.
- 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
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
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
phpMyAdmin will ask you to confirm the deletion request. Click on OK to delete the table.
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.
If you have any web hosting questions please feel free to reach out to us. We're happy to help.
Shared Hosting | Reseller Hosting | Managed WordPress Hosting | Fully Managed VPS Hosting
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.