Re: renaming a cloumn

From: Sue Wi-Afedzi <suewi_at_uoguelph.ca>
Date: Tue, 11 Dec 2001 14:20:03 -0500
Message-ID: <9v5m3s$8er$1@testinfo.cs.uoguelph.ca>

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 - 13:20:03 CST