Re: Changing Table Column Name

I am not sure if there is a direct path to rename a column, but if you are using Oracle8i you can add the new column Societe, copy the information from NomSocie to Societe and drop a column NomSocie with command
ALTER TABLE Chefpro DROP COLUMN NomSocie

Hope this helps

Ould wrote:

> Hello Listers,
>
> I have a table like this :
> Chefpro (NomSocie, nomVille, ....).
> I want simply to change the name of attribute "NomSocie"
> to becomes "Societe".
> How I can do this using a command like ALTER
> and conserving the data already existing.
>
> Thanks
>
> Mohamed est de retour!

--
Breno de Avellar Gomes
Database Applications & Internet Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
4017-001 Porto
Portugal

brenogomes_at_ieee.org
Cellular: +351 931 7383469
ICQ # 35567342

Toll free fax and voice recorder from USA
1-888-EXCITE2  extension  291-303-8152

Outside USA (international fares apply)
1-917-463-3173