Deleting tables from a database with phpMyAdmin

phpMyAdmin lets you drop an entire table from a database in just a few clicks. Be aware that this permanently deletes the table and all the data it contains.

Delete an entire table

1. Open phpMyAdmin from cPanel and select your database from the left-hand panel.
2. Click the name of the table you want to delete.
3. Click the Drop link (in the table list, or on the Operations tab).
4. phpMyAdmin asks you to confirm the DROP TABLE command - click Yes.

The table is removed from the database and no longer appears in the table list.

Remove individual columns instead

If you only want to remove specific columns rather than the whole table:

1. Select the table from the left-hand panel.
2. On the Structure tab, tick the checkbox next to each column you want to remove.
3. Click the Drop link at the bottom of the column list.
4. Confirm when prompted.