Delete a column from an existing MySQL table
Contributed by qmchenry 
Tagged: 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'
Thennarasu said on November 1, 2008
Ya it works…
kiran said on December 7, 2008
helpful in coding.thank u.
Dan said on January 3, 2009
try myNet.Office
at: http://www.NetthruOffice.com
Mercy said on January 7, 2009
Thank u. It is useful
mysql said on January 20, 2009
use it without ( ‘ )…
steve said on February 13, 2009
yep:
ALTER TABLE table_things DROP col_stuff
Neelesh said on February 24, 2009
If we want to check whether that column exit, if exist only then delete the column so that our script does not hamper.
jaswath said on April 16, 2009
thanks it solved problem
vol said on April 21, 2009
ALTER TABLE table_things DROP col_stuff;
A said on June 15, 2009
ALTER TABLE room DROP COLUMN y;
dennis said on December 11, 2009
ALTER TABLE `article` DROP column `homepage`;
Need to use key word column with my version of mysql. 5.1.41-1
Anonymous said on March 12, 2010
Exactly what I needed. Thanks.
vishnu said on June 3, 2010
yes…….Thanks for
DID said on June 24, 2010
It Dosn`t work in my machine
Aishwarya said on July 7, 2010
Thanks for ur valuable information
Sss said on July 30, 2010
love u
Rahuljain Iips said on August 25, 2010
Gud One
Test said on October 1, 2010
its working
Anonym said on December 18, 2010
Thanks so much!
Abcdasdasdasd said on February 10, 2011
Exactly what I needed. Thanks.
sam said on February 25, 2011
thanks
Arun mohapatra said on March 19, 2011
Thans a lot dear….
Kili said on April 1, 2011
poda…………..
Mail said on April 29, 2011
thanks works
Pawankjajara said on June 30, 2011
Awesome Query, works fine !
Karthikeyan said on October 9, 2011
Thank you so much dude. Good Work.