Re: Can I rename a column name?

From: Andrew Babb <andrewb_at_mail.com>
Date: Sat, 01 May 1999 09:17:37 +0800
Message-ID: <372A5631.5AB318A9@mail.com>

Hi,

Afraid to say that you cannot rename a column in a table, and that the only support way is as you suggest.

I have attempted this with updating the data dictionary, but have not been 100% successful, especially when the table is real (PK's, FK's, Constraints, Triggers, Packages, etc...) Also, it's not supported at all.

Rgds
Andrew

yong321_at_yahoo.com wrote:

> In Oracle 7, can I rename a column name, or I have to do it by creating a new
> table with the new column name (and drop the old table)?
>
> Yong
> Email:yong321_at_yahoo.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 30 1999 - 20:17:37 CDT