Re: Changing Column Names

A copy of this was sent to "Craig Despres" <csdespres_at_callsynergy.com> (if that email address didn't require changing) On Fri, 15 Oct 1999 01:21:20 GMT, you wrote:

>Is there any way to rename a column in an existing table without dropping it
>and adding it back into the table with the correct name?

The way to do this is:

• rename the table using the rename command.
• create a view with the name of the original table that names the columns as you wish.

In Oracle8i, release 8.1, you can:

• alter table add column with new name.
• update table set new_name = old_name;
• alter table drop column old_name;

but i would always still prefer method 1 as it is the fastest, easiest, least error prone way to do it.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Oct 15 1999 - 07:46:50 CDT