Re: ehm... drop column...

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