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.
    BeforeAfter
    before table deletionafter table deletion
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Support Center:
Email Address
Optional, but our team may contact you for more information.
Like this Article?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

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

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

Need more Help?

Search

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: support@InMotionHosting.com
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!