Re: Alter Table

From: Marcel Lipman <no.spam_at_my.address>
Date: 1998/01/07
Message-ID: <EMEwC3.GBs_at_wau.mis.ah.nl>#1/1

In article <68plp4$lbs$1_at_usenet51.supernews.com>, "Steven R Fuller" <srfuller_at_doitnow.com> wrote:
>Is there any way to alter a table, I want to change a column name only and
>retain all the data within that column.

One way of doing it is to create a temporary table first with the desired structure, copy the data into the temp table, drop the old table, and rename the temp table to the old one.     

+----------------------------------------------+
| Email address: mlipman at iname dot com      |
|                                              |

| Not to be confused with: billg_at_microsoft.com |

+----------------------------------------------+

Received on Wed Jan 07 1998 - 00:00:00 CET