Delete a column from an existing MySQL table

Posted March 18, 2004 by Quinn McHenry in MySQL

The SQL command in this recipe removes a column and the column’s data from an existing MySQL table.


To delete the column col_stuff from the table table_things, use the following SQL command:

ALTER TABLE 'table_things' DROP 'col_stuff'

 

About Quinn McHenry

Quinn was one of the original co-founders of Tech-Recipes. He is currently crafting iOS applications as a senior developer at Small Planet Digital in Brooklyn, New York.
View more articles by Quinn McHenry

The Conversation

Follow the reactions below and share your own thoughts.