Re: RENAME COLUMN

From: <rspeaker_at_my-dejanews.com>
Date: Mon, 22 Feb 1999 19:51:17 GMT
Message-ID: <7ascfh$kf9$1@nnrp1.dejanews.com>

typically what I do is create a "temp" table that mirrors the original table, copy all data from the original table into the temp table, drop the original table and recreate with the correct column name(s) and then copy the data from the temp table back to the new table. When all is done and verified drop the temp table.

HTH,
Roy

In article <pyfA2.495$Zp3.18767_at_carnaval.risq.qc.ca>, "RL" <rlavoie63_at_hotmail.com> wrote:
> Hi everybody!
>
> What's the easy way for rename a column in a table ?
>
> Thank's
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 22 1999 - 13:51:17 CST