How can I remove a column from an existing table?
The way I do it is like this:
select field1, field2, field3, field5 into newtable from oldtable; drop table oldtable; alter table newtable rename oldtable;
check the syntax, I'm not sure all that's really correct. But you get the jist.
