Re: Changing column names

Hi from Germany,

I'm sorry, but there's NO way to simply rename a column. Maybe you can try the following:
Add a new column to the table, issue an update statement to put the data from the old column into the new one, then set the old column to null and forget it...
I know that this is not very beautiful ;-).

HTH
Guido

R Fray schrieb:

> 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