InMotion Hosting Support Center

When working with databases, you can use the phpMyAdmin tool to create database, tables, and add content. Along with normal data addition, you may also need to reorganize the way your data is stored. This may involved removing data, or even deleting tables from you databases. This tutorial will guide you on the process of dropping a table within the phpMyAdmin database management tool.

Note that when deleting or dropping a table, the data will be removed permanently. Please ensure that you do not need the data for any program before dropping the table.

Deleting or dropping a table in phpMyAdmin

  1. Log into your cPanel interface.
  2. From the main cPanel screen, look for the Databases category and click on the phpMyAdmin tool icon.
  3. click databases button Once you are in the phpMyAdmin tool, find and click on the database name that contains the table you want to drop.
  4. select the drop link for desired tableAfter clicking the database name, the tables will be listed in the right hand panel. Locate the table you want to drop and select the Drop link.
  5. You will receive a popup. Click the OK button to confirm the delete.
  6. You will receive a deletion success message and see your table disappear from the list. Below is a quick before and after shot of the table list for a successful deletion.
    before table deletionafter table deletion
Was this article helpful?

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

n/a Points
2015-08-31 4:00 am

What would be really useful is to teach us how to drop the prefix too "_test"

and what if there are many of them?

43,761 Points
2015-08-31 1:21 pm

Are you meaning the prefix of the tables? such as wp_options (for wordpress tables) or the database itself such as userna5_test? Prefixes of tables are set within their specific CMS. Table prefixes are set by the server and not possible to remove on a shared environment.

Kindest Regards,
Scott M

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

2 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!