Karel Zak wrote:
>
> On Tue, 30 May 2000, G. Anthony Reina wrote:
>
> > Somehow some columns from one of my tables "melded" with another table.
> > I'm trying to figure out how this happened, but in the meantime, I'd
> > like to be able to delete the extra columns in the table.
> >
> > I can see a way to "alter table ... add column". Is there a way to
> > "alter table ... drop column"?
>
> SELECT without_a_column INTO xxx FROM tab;
> DROP TABLE tab;
> ALTER TABLE xxx RENAME TO tab;
>
> OK?
>
I could have sworn this was supposed to be added into version 7. Did
they just make "alter table drop column" into a alias for using a temp
table?