How to delete a table in a database with phpMyAdmin

phpMyAdmin is a popular application for managing MySQL databases. Should you need to delete a database table, you can use phpMyAdmin to complete the task quickly.

First, log in to the HostPapa Dashboard and select My cPanel from the top navigation menu. In the cPanel menu, scroll down to the Databases section and select phpMyAdmin.

cPanel

Use the navigation tree in the left sidebar to locate the database table you wish to delete.

phpMyAdmin

Database fields are now listed in the main pane. You can check a field and use the Delete button to discard individual fields.

Delete table

To delete the whole table, select the Operations tab at the top of the screen.

Operations table

Now select Delete the table (DROP) at the bottom right of the screen.

Delete tables

You’ll be asked to confirm deletion. Do so and the table will be removed from the database.

If you notice any problems or if you need any help, please open a new support ticket from your HostPapa Dashboard. More details on how to open a support ticket can be found here.

 

Was this article helpful?

Related Articles

Leave A Comment?