# Deleting fields from database tables with phpMyAdmin

> Learn how to delete a field (column) from a database table using phpMyAdmin in cPanel, and how to do it safely.

Source: https://www.kualo.com/knowledgebase/cpanel-databases/deleting-fields-from-database-tables-with-phpmyadmin
Updated: 2026-06-11

---

If a field (column) is no longer needed, you can remove it from a table in phpMyAdmin. This permanently deletes that column and everything stored in it, so it is worth a quick check before you confirm. This guide shows how.

## Before you start

Open phpMyAdmin from the **Databases** section of cPanel, click your database, then click the **table** you want to change. New to phpMyAdmin? See [Becoming familiar with databases in phpMyAdmin](/knowledgebase/cpanel-databases/becoming-familiar-with-databases-in-phpmyadmin).

:::warning
Deleting a field also deletes all the data stored in it, and this cannot be undone. If the table holds anything important, [export a backup](/knowledgebase/cpanel-databases/exporting-databases-and-tables-with-phpmyadmin) first.
:::

## Delete a field

1. With the table open, click the **Structure** tab.
2. In the **Action** column next to the field you want to remove, click **Drop**.
3. phpMyAdmin asks you to confirm, showing the exact command it will run. Check that it names the correct field, then click **OK**.

   ![The confirmation prompt before dropping the phone field](https://kb-cdn.kualo.com/01/e5/01e5ab99fda69d5f5b257d8f61cafacfe5ca5bd5.png)

The field is removed immediately, and the **Structure** view updates to show the remaining columns.

![The members table structure after the phone field has been removed](https://kb-cdn.kualo.com/85/de/85de8abfc578bd1c32ed528c4ea03efd140fef7b.png)

:::tip
To remove several fields at once, tick the checkbox beside each one, then choose **Drop** from the **With selected** menu below the list.
:::

To add a field, see [Inserting fields into database tables](/knowledgebase/cpanel-databases/inserting-fields-into-database-tables-with-phpmyadmin); to edit one, see [Modifying fields in database tables](/knowledgebase/cpanel-databases/modifying-fields-in-database-tables-with-phpmyadmin).

If you need a hand, our support team is available 24/7 - just [open a support ticket](/knowledgebase/getting-started/how-to-create-a-support-ticket-in-mykualo).


---

_Source: Kualo Knowledgebase — https://www.kualo.com/knowledgebase/cpanel-databases/deleting-fields-from-database-tables-with-phpmyadmin · © Kualo Ltd._