Re: Alter Table

From: Brad Murray <BradMurray_at_SeeSignatureIfThere.com>
Date: 1998/01/07
Message-ID: <MPG.f1dbc0f9ee4b765989889_at_news>#1/1

In article <01bd1ba1$114d38c0$27866cc2_at_h-h.sh.cvut.cz>, hrd_at_dcit.cz said...
> 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.

And triggers, and table partitions, and security, and re-validate any views on the table, and ...

---

 Bradley S. Murray Princeton Computer Consulting (609) 730-9100  BradMurray(-at-)usa.net Pennington, NJ 08534-3612 Fax: 275-5651 Received on Wed Jan 07 1998 - 00:00:00 CET