Re: Changing Table Column Name

You can't....The name of a column is not an 'alterable' characteristic so you may want to create a view of the table with the column name(s) you want to use - say V_Chefpro and then create a public synonym for that view that is the same as the table name ( if you have a synonym for that table drop it first ( the synonym, NOT the table! ), like this - create public synonym Chefpro for V_Chefpro..

so anyone doing a select on Chefpro will actually be selecting from v_Chefpro

HTH, John Greco

Ould <ould_at_darea.fr> 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!
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Oct 20 1999 - 18:27:17 CEST