Re: newbie question on sql

From: Andrew Simkovsky <asimkovsky_at_email.msn.com>
Date: Mon, 16 Apr 2001 14:15:24 -0400
Message-ID: <#Kj2eAqxAHA.328@cpmsnbbsa07>

In 8i you can add a new column with the name you want, copy the data from old column to new column, then drop the old column.

Andrew Simkovsky
OCP DBA "Steve Long" <steven.long_at_erols.com> wrote in message news:9bc3aj$mhg$1_at_bob.news.rcn.net...
> you can create a new table with the desired column names and then
move/copy
> the rows into the new tale, then drop the old table.
>
> "webbug" <NOSPAMbandlover_at_hotmail.com> wrote in message
> news:20010415.181554.846811127.4449_at_localhost.localdomain...
> > hello all,
> > is it possible to rename a column of a table?
> > if not, any other alternatives?
> > thanks
>
>
Received on Mon Apr 16 2001 - 13:15:24 CDT