Re: Changing Column Names

From: John F. Keaveney <johnkeaveney_at_targusinfo.com>
Date: Thu, 21 Oct 1999 09:59:17 -0700
Message-ID: <7unhha$kju$3@ffx2nh3.news.uu.net>

If you have a table X with columns A,B,D I do this

create table Y as select A,B,D C from X

(alias D to C)

then drop X and rename Y

John

Rod Stewart <rod.stewart_at_afp.gov.au> wrote in message news:7u60n0$l39$1_at_platinum.sge.net...
> Basically, no there isn't.
>
> Craig Despres <csdespres_at_callsynergy.com> wrote in message
> news:kkvN3.8830$pL5.10956_at_news.rdc1.az.home.com...
> > Is there any way to rename a column in an existing table without
dropping
> it
> > and adding it back into the table with the correct name?
> >
> > --
> > Craig Despres
> > Synergy Solutions Inc.
> >
> >
>
>
Received on Thu Oct 21 1999 - 11:59:17 CDT