How To Drop Columns From A Database In phpMyAdmin

phpMyAdmin Tool is used to manage databases and perform different actions on tables used in a particular database. Example – User can use phpMyAdmin Tool to delete or drop columns from a database

To drop columns from a database-

1. Login to cPanel

2. Search for phpMyAdmin and click on it

3.  On the next page, phpMyAdmin Home Page opens which shows all the options that can be accessed

4. Select the database from where you want to drop columns

5. After selecting a particular database, it fetches the list of tables that are in that database

6. Select a particular table by clicking on it

7. After clicking on a particular table, the user can see list of columns used in that table. User can drop any column by selecting drop button

8. After selecting the drop button, a pop-up is shown on the screen which asks for confirmation. If the user selects the OK button, that particular column will be dropped from that table