Knowledge Base
MilesWeb / Database, How-Tos, phpMyAdmin

How to Drop Columns from a Database Using phpMyAdmin?

Approx. read time : 3 min

Watch this video for a step by step process on how to Drop Columns from a Database Using phpMyAdmin

With phpMyAdmin, users can make alterations to their MySQL and MariaDB databases. This tool is available on cPanel, Plesk and DirectAdmin as well. You can even delete columns from a database via phpMyAdmin.

To Drop Columns from a Database Table via phpMyAdmin

Note: Before beginning, we recommend you create a backup for the database as the following actions will result in the permanent loss of some data.

1. Log in to your control panel(cPanel, DirectAdmin or Plesk) account.

2. Browse and click on phpMyAdmin.

3. The phpMyAdmin window will open. Select a database from the list.

4. Click on the ‘+’ icon beside the table whose columns you wish to drop.

5. Click on Columns. A panel showing the list of columns and functions will appear.

6. Tick beside the column you want to delete/drop and then click Drop.

Note: The Drop function permanently deletes the column and all its data from your database. You have to be sure that this action will not affect your database later as the data would be beyond recovery.

7. A pop-up window will display the details of the column that is to be dropped. After confirming the details, Click OK.

phpMyAdmin will delete the column from the table permanently.

Prasad Khartadkar
Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.

Trusted By Thousands of Clients & Big Businesses

We highly appreciate the kind and stellar feedback we receive from our customers. Delivering the best is our goal! MilesWeb is rated Excellent 4.8 out of 5 based on reviews. Read more reviews.

Excellent
Based on reviews
2 hours ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
4 hours ago
Milesweb is superb Hosting pro...
Milesweb is superb Hosting provider ever, their Support team is amazing!!!...
Abhishek Singh
15 hours ago
Great support in great timing...
We need urgent assistance on changes in a primary domain on our client's Cpanel accounts and reached...
Riyaju Deen
21 hours ago
Best Website Hosting platform ...
I was new on MilesWeb. And needed help on multiple areas from setting up to getting started with cre...
Harshada
1 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
1 days ago
the team is very supportive th...
the team is very supportive though at times effort needs to be made to make understand the problem s...
Suree Sharma
1 days ago
I am using miles web for 3plus...
I am using miles web for 3plus years, very quick and perfect support by the team, they helped me man...
Sri Raghav
2 days ago
The service is good...
The service is good. They are answering with patience and doing the needful as soon as possible....
MR
2 days ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
3 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
4 days ago
positively helped me with find...
positively helped me with finding insecure content on my website causing SSL to not work properly on...
Thaviraj Junglee
4 days ago
Exceptional support, Truly Pra...
I had opted for the basic wordpress hosting plan as I intended to experiment with various plug-ins. ...
Aseem Chandna