Re: Can Oracle drop a column?

This is one of those things that are on my wish list. It would be nice to
drop columns. Alternately, you can set the column width to 1 (or try 0, that may work)
and leave it alone, or create a new table with the new column and do an insert.

I have heard that there are 3rd party utilities that basicly do this for you.

Best wishes!

Bob Acker
>
> Hi there :
> The table has about 1m of data. I want to drop a column of that table.
> It seems like Oracle doesn't allow me to do that. When I use ALTER TABLE
> command. The only thing I can drop is the constraints. Some may suggest to
> create a temporary table, then use INSERT to transfer the data.(It takes
> some time) Is there any other ways?
> TIA
>
> Kathy Fangyao
Received on Sun May 25 1997 - 00:00:00 CDT