Re: delete a column

From: Dr. Jan Dieckmann <jdieckmann_at_psi.de>
Date: 1998/03/13
Message-ID: <35091E11.1EE9@psi.de>#1/1

Tony de Lange wrote:
>
> 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

You can drop columns with our tool Hora 3 (a free trial version is available at www.keeptool.com). Hora will do everything for you except updating views, procedures, functions and packages.

regards Jan Dieckmann
Jan.Dieckmann_at_KeepTool.com Received on Fri Mar 13 1998 - 00:00:00 CST