Re: Renaming a column

Or may be u can try something like this....

create table A as select old_name new_name ,col1,col2,,,,, from table ;

HTH.
Ashesh

In article <7004rs$l4p$1_at_news00.btx.dtag.de>,   "Nicolas Bronke" <NBronke_at_Trinity.de> wrote:
> Until now, NO
>
> clucas_at_my-dejanews.com
> >Hello,
> >
> >Is there any way to rename a column in a table?
> >
> >I mean, without exporting / dropping table / recreating it / importing.
> >
> >Thanks for your help!
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 14 1998 - 13:01:03 CDT