phpMyAdmin is one of the most popular and important application used to manage MySQL Database. phpMyAdmin allows you to create, make changes, drop, delete, import or export MySQL Database tables. It also allows you to run MySQL queries and execute other MySQL Database management commands. In this tutorial, you will learn how to drop columns from a database in phpMyAdmin.

Below are steps to follow while dropping columns:-

Heads up! Dropping columns from a database table, deletes the column data and all the data in the column.

1. You begin by accessing your phpMyAdmin via Cpanel
2. Go to your left side of the phpmyadmin, select the database that has the table you want to modify.
3. Inside the database you selected, you’ll find all your database tables. Click on the structure link next to the name of the table that should be modified.
4. Place a check mark on the column you wish to drop/delete.
5. Underneath the list of columns click on the Delete button.
6. Immediately you click it will ask you “Do you really want to execute the following query?” Counter check on what will be dropped to make sure it’s the right column you are about to drop. If it is right column, click on the YES Button to continue. If otherwise then click NO Button.
7. When you click YES Button to continue, message stating your SQL query was executed successfully will be displayed meaning your columns has been dropped.