Drop Columns

Use alter table to drop a column from an existing table.

You can drop any number of columns using a single alter table statement. However, you cannot drop the last remaining column from a table (for example, if you drop four columns from a five-column table, you cannot then drop the remaining column).

For example, to drop the advance and the contract columns from the titles table:
alter table titles
drop advance, contract

alter table rebuilds all indexes on the table when it drops a column.