What does Drop a Table Mean?
To drop a table means deleting the table and its contents from the database.
Dropping a table cannot be undone.
The
learnsql.comDROP TABLEis another DDL (Data Definition Language) operation. But it is not used for simply removing data from a table; it deletes the table structure from the database, along with any data stored in the table.
Why would you Drop a Table?
Sometimes, you no longer need a table. As I learn more, I experiment and improve my databases. As a result, sometimes I realize I never need a certain table ever. So I drop that table.
How to Drop a Table using phpMyAdmin
Go to phpMyAdmin.
Click on the database name in the left column.
Click on the table name in the left column.
You will see the table contents.
Click on the Operations tab.
You will see this.
Go to the very bottom of the webpage and click on Delete the Table (DROP).
Click OK to confirm you want to drop the table.
The table is dropped.
