Knowledge Base
How to Drop Tables from a Database in phpMyAdmin
Learn how to permanently delete database tables using phpMyAdmin in cPanel. This guide explains how to drop one or more tables, outlines the difference between the Drop and Empty options, and highlights important precautions to help prevent accidental data loss.
Before proceeding, we strongly recommend creating a backup of your database. Dropping a table permanently removes the table and all its data. Without a backup, deleted tables and their contents cannot be recovered.
WARNING! Dropping a table permanently deletes the table and all data stored within it. Before continuing, ensure that no websites, applications, or services rely on the data contained in the table(s) you plan to delete.
To drop an entire table from your database
- Log in to cPanel.
- In the Databases section, click phpMyAdmin.
- In the left navigation panel, select the database that contains the table(s) you want to manage.
- The database tables will appear in the right pane.
- Select the checkbox next to the table(s) you want to modify.
- At the bottom of the table list, locate the With selected: dropdown menu.
- Choose one of the following options:
- Drop: Permanently deletes the selected table(s) and all associated data.
- Empty: Removes all records from the selected table(s) while preserving the table structure.
- Review your selection carefully to ensure you have chosen the correct table(s).
- Click Yes to confirm and proceed with the action.
Deleting a table may cause your website or application to stop functioning properly if it relies on the data stored in that table.Alternatively, you can click the Drop or Empty displayed alongside an individual table to perform the same action.
A confirmation window will appear. Review the table name to ensure you selected the correct table, then click OK to permanently delete the table and its data.
Once confirmed, the selected table(s) and all associated data will be permanently removed from the database.
Did you find this article helpful?