Re: What is the way to rename or delete columns?

From: Jan Nowitzky <nowitzky_at_informatik.uni-jena.de>
Date: Thu, 12 Aug 1999 08:30:51 +0200
Message-ID: <37B26A1B.4577BCE5@informatik.uni-jena.de>

Hi,

in my eyes the following should be the best strategy:

(1) rename the table,
(2) create view old_table (new_column_list) as select renamed_table_column_list from renamed_table

You can also do this:

(1) create new_table (renamed_column_list) unrecoverable as select * from table

In Oracle8.1.x you have this opportunities:

alter table ... add column .....
update table set new_column = old_column
alter table ... drop column ....

Regards, Jan

John wrote:

> Hi,
>
> My database server is Oracle 8.05 for NT.
>
> It seems there is no way to delete or rename columns directly, but what is
> the best way to rename or delete columns?
>
> Thanks!
>
> John

Jan Nowitzky o Friedrich-Schiller-Universität o Institut für Informatik o

D-07740 Jena o
E-Mail nowitzky_at_informatik.uni-jena.de
---------------------------------------------------------------------------

Received on Thu Aug 12 1999 - 01:30:51 CDT