Delete a column from an existing MySQL table
Contributed by qmchenry 
March 18, 2004 
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'
Add New Comment
Viewing 1 Comment
Thanks. Your comment is awaiting approval by a moderator.
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
Add New Comment