Re: Alter Table

If you find that you have to do things like this very often, it becomes a real pain in the neck to do manually. There is a data modeling tool called Infomodeler (www.infomodelers.com) that automates this process. If you change something in the model, then when you synchronize with the physical database, it will automatically drop and recreate the table, keys, etc and preserve the data for you. Infomodeler is also a heck of a modeling tool as well.

Thanks,

Bill MacLean

Hrdlicka Jan <hrd_at_dcit.cz> wrote in article <01bd1ba1$114d38c0$27866cc2_at_h-h.sh.cvut.cz>...
> 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 Fri Jan 09 1998 - 00:00:00 CET