Using this option, you can delete a column from a table. Note that this will remove a column and all of its data from a table permanently. The data destroyed in this manner can't be recovered.
To delete a column from the table, select "Alter" from the "Select" list . Choose the "Drop" option of the "Alter" list, then select "Column" from the next list. Choose the column you want to drop from the "Column Name" list and click the "Build SQL Query" . After reviewing the SQL query click the "Run SQL Query" to complete the operation. The result of operation will be displayed at the bottom of the page.