Re: Changing column names

From: John F. Keaveney <johnkeaveney_at_targusinfo.com>
Date: 1998/09/09
Message-ID: <6t710h$mp0$2@news1-alterdial.uu.net>#1/1

I don't know of any way of doing this. You can create a new table and rename the column at the same time like

create table newtable as select a,b,c,badname d,e,f from oldtable

this will rename the column badname to d via the alias mechanism

John

R Fray wrote in message <35f5a8de.93646422_at_news.u-net.com>...
>
>Hi,
>
>Could somebody tell me the SQL / Oracle syntax for changing a column
>name that contains data, without losing the data?
>
>I would have thought schema-manager would allow this, but I can't see
>an obvious way - therefore I am hoping there is a simple 'update'
>command in SQL that somebody could show me :)
>
>Please cc replies to russ_at_u-net.net
>
>Regards,
>Russell.
>
>
>--
>
>Russell Fray
>U-NET Ltd.
Received on Wed Sep 09 1998 - 00:00:00 CDT