Re: Renaming a Column

Here's what the FAQ says (http://www.orafaq.com/faqsql.htm#RENAMECOL):

Can one rename a column in a table?
No, this is listed as Enhancement Request 163519. Workarounds: 1. rename t1 to t1_base;

   create view t1 <column list with new name> as select * from t1_base;

2. create table t2 <column list with new name> as select * from t1;

   drop table t1;
   rename t2 to t1;

Randall Woodman wrote:

> Sorry for the cross post but I'm desperate for an answer.
>
> Is there a way to rename a column in an existing table? For example,
> suppose I had a table named FOO.
>
> CREATE TABLE FOO (
> FOOWHO VARCHAR2 (12) NOT NULL,
> BARNONE VARCHAR2 (18) NOT NULL,
> FOOBAR VARCHAR2 (8) NOT NULL,
> )
>
> Now suppose I want to rename the column FOOBAR to FUBAR. I know I could do
> the following
> 1. Add a new column called FUBAR
> 2. update the column FUBAR with the data in FOOBAR
> 3. Drop the column FOOBAR
>
> However, I was thinking that there was a way to do this using a single
> ALTER statement. For example,
> alter table <table_name> rename column <column_name> new_column_name
> However, that doesn't work.
>
> I'm running Oracle 8.1.6
>
> Thanks for your help.
>
> -=} Randall {=-
Received on Mon Jul 16 2001 - 13:59:24 CDT