Re: Alter Table
From: Hrdlicka Jan <hrd_at_dcit.cz>
Date: 1998/01/07
Message-ID: <01bd1ba1$114d38c0$27866cc2_at_h-h.sh.cvut.cz>#1/1
Date: 1998/01/07
Message-ID: <01bd1ba1$114d38c0$27866cc2_at_h-h.sh.cvut.cz>#1/1
Marcel Lipman <no.spam_at_my.address> wrote <EMEwC3.GBs_at_wau.mis.ah.nl>...
> >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.
>
Don't forget recreate forein keys after this operation.
Jan Hrdlicka
DCIT Czech republic
Received on Wed Jan 07 1998 - 00:00:00 CET