How to Drop Tables from a Database in phpMyAdmin

This article will walk you through how to drop or permanently delete tables from a database in phpMyAdmin. Please note that this process will delete the table and everything in it.

To drop an entire table from your database:

1. Log in to cPanel. There are two ways to access your cPanel.
   • Option 1: Access your cPanel directly.
   • Option 2: Access your cPanel via your Customer Portal.
     1. Log in to your Customer Portal.
     2. Click Hosting in the left-side menu.

        

     3. If you have a single hosting package in your account, scroll down to the Quick Links section.

        
        If you have multiple hosting packages in your account, locate the hosting package you want to manage on the Hosting Packages page, then click its Manage button.

        

     4. Under the Quick Links section, click the cPanel button.

        

2. Within cPanel, go to the Databases section and click the phpMyAdmin icon.

   

3. In the left column of the phpMyAdmin homepage, select the website's database you want to work on.

   

4. The database's tables will appear in the right pane.

   

5. In the right pane, 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 to be completely gone. If you want to clear the data in the table and keep its structure, select Empty.

   

8. You will be prompted if you really want to drop the table(s). Check again to ensure you selected the correct tables you 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.

   

10. 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.