Обсуждение: ehm... drop column...

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

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

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