---
title: "How to Delete or Drop a Table in phpMyAdmin"
description: "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...."
url: https://www.inmotionhosting.com/support/website/drop-table/
date: 2013-04-22
modified: 2021-10-28
author: "Scott Mitchell"
categories: ["Website"]
type: post
lang: en
---

# How to Delete or Drop a Table in phpMyAdmin

When working with databases, you can **use the [phpMyAdmin tool](/support/) 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.

![How to Drop a Database in phpMyAdmin](https://i.ytimg.com/vi_webp/MC5cIkRehQI/maxresdefault.webp)

## Deleting or dropping a table in phpMyAdmin

1. [Log into your cPanel interface](/support/edu/cpanel/how-to-log-into-cpanel/).
2. From the main cPanel screen, look for the *Databases* category and click on the **phpMyAdmin** tool icon.
3. [![click databases button](https://www.inmotionhosting.com/support/wp-content/uploads/2013/04/edu_phpmyadmin_drop-table_click-db.png)](/support/wp-content/uploads/2013/04/edu_phpmyadmin_drop-table_click-db.png) 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 table](https://www.inmotionhosting.com/support/wp-content/uploads/2013/04/edu_phpmyadmin_drop-table_2-click-drop.png)After 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.](/support/wp-content/uploads/2013/04/edu_phpmyadmin_drop-table_2-click-drop.png)
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 After [![before table deletion](https://www.inmotionhosting.com/support/wp-content/uploads/2013/04/edu_phpmyadmin_drop-table_before.png)](/support/wp-content/uploads/2013/04/edu_phpmyadmin_drop-table_before.png) [![after table deletion](https://www.inmotionhosting.com/support/wp-content/uploads/2013/04/edu_phpmyadmin_drop-table_after.png)](/support/wp-content/uploads/2013/04/edu_phpmyadmin_drop-table_after.png)