1. Home
  2. Computing & Technology
  3. PHP / MySQL

Drop Column - MySQL Command

By , About.com Guide

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 [table name] 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".
Explore PHP / MySQL
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. MySQL Commands
  5. SQL Drop Column - MySQL Drop Column - Drop Column

©2009 About.com, a part of The New York Times Company.

All rights reserved.