Re: delete a column

From: Tony de Lange <tony.delange_at_alusaf.com>
Date: 1998/03/12
Message-ID: <6e8u3e$hqa$1@news01.iafrica.com>#1/1

The only way I know of to delete a column is to recreate the table. You can do this by creating a"backup" table as select * from your table, then recreating your new table without the column and inserting the data from your "backup" table.
Be carefull though with constraints, invalidated packages and views and those type of things.

Paul Kreis wrote in message <3507BA1C.4760_at_ascom.ch>...
>I'm new in Oracle and SQL, my question:
>How can I delete one column in a table, and how can I rename a
>columns. I tried it with the alter table statement, but it didn't
>work.
>
>regards,
>--
>=================================================================
>Paul C. Kreis Informatiker Ascom
> Phone: ++41(0)31 999 6605
>paul.kreis_at_ascom.ch Natel: ++41(0)79 432 0514
Received on Thu Mar 12 1998 - 00:00:00 CST