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