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!"
> -----------------------------------------------------------------------------