Re: DROP column

From: TurkBear <johng_at_nospam.mm.com>
Date: Tue, 13 Oct 1998 21:10:07 GMT
Message-ID: <3623c109.23499470@news2.mm.com>

Unless v8 has changed the rules, you cannot drop a column....

Create a new table with a 'create table temp_new_table as select < all but the column you want to drop > from table1 ' Drop original table
Rename temp_new_table to original table's name

Note : any constraints, indexes, permissions, etc will need to be re-created..

Sorry..

"sassco" <sassco_at_erols.com> wrote:

>Does anyone know how to drop a column from a table in Oracle 8...
>
>ALTER TABLE DROP... does not work...
>
>
>Thanks in advance...
>
>T.S.

To reply please remove the 'nospam' part of the address Received on Tue Oct 13 1998 - 16:10:07 CDT