Re: ehm... drop column...

3. Wait to january (hopefully not longer) when version 7.1 will have the
new "DROP COLUMN" command.

"D. Duccini" wrote:
>
> its not really possible
>
> best bet is to
>
> 1. rename the column to something
>
>    oldcolumn
>
> optionally
>
> 2. create a new table, and select into this new "clean" table, and the
> drop the old one
>
> On Tue, 31 Oct 2000, andrea gelmini wrote:
>
> > hi all,
> >       i'm going mad trying to find a way to delete a column
> >       in a table.
> >       if i try it like in oracle, with alter, it doesn't
> >       work, and i didn't find anything in the docs...
> >       so, i'm afraid it's not possibile...
> >
> > thanks for your time,
> > andrea
> >
>
> -----------------------------------------------------------------------------
> david@backpack.com            BackPack Software, Inc.        www.backpack.com
> +1 651.645.7550 voice       "Life is an Adventure.
> +1 651.645.9798 fax            Don't forget your BackPack!"
> -----------------------------------------------------------------------------