Delete a column from an existing MySQL table
Posted March 18, 2004 by Quinn McHenry in MySQL
Last Updated on
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
View more articles by Quinn McHenry
The Conversation
Follow the reactions below and share your own thoughts.