Deleting a table using phpMyAdmin
To delete a table in a MySQL database using phpMyAdmin, follow these steps:-
Log in to cPanel.
📘 Note If you do not know how to log in to your cPanel account, please see this article.
-
On the Tools page, in the Databases section, click phpMyAdmin:
-
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:
-
In the right pane, select the check box for the table that you want to delete:
-
In the With selected list box, select Drop.
👍 Tip Alternatively, if you want to keep the table, but delete all of the data that it contains instead, select Empty .
-
To disable foreign key checks, clear the Enable foreign key checks check box.
🚧 Important 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.
- phpMyAdmin confirms that you want to delete the table. Click Yes.