Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: renaming a cloumn
Hi,
this is not correct. I think since 8.1.7 it is possible to rename columns. I have done it a few weeks ago, but can't remember the syntax. If you have installed the help you should a have a look at the parameters for "alter table modify column". I think it was "move" but I'm not sure.
Hope this helps,
Holger
Sue Wi-Afedzi schrieb:
> You can't rename a column, but you can add a new column with the new name,
> (alter table add ...), populate it with the values of the first column, then
> drop the first column (alter table drop column <column name>). The
> database must be 8i or higher and the owner of the table cannot be SYS.
>
> Hope that helps.
>
> Sue
> "Najm Hashmi" <najmh_at_videotron.ca> wrote in message
> news:wtjR7.18657$2F2.1189458_at_weber.videotron.net...
> > Hi All,
> > What is the correct syntax to rename a column in a table using alter table
> > command.
> > Thanks in advance.
> > Regards, Najm
> >
> >
Received on Tue Dec 11 2001 - 17:19:50 CST