1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Drop Column - MySQL Command

By

Young woman in cafe with netbook
Alexey Tkachenko/E+/Getty Images
Definition: Drop column is used to remove a column from a given table. This also removes all data from the column. It is written as alter table drop column [column name];
Also Known As: MySQL Drop Column, Remove Column, Delete Column
Examples:
alter table icecream drop column flavor; 
This removes the column "flavor" from the table called "icecream".