Re: How do you rename a column in a table?

From: Vadim Grepan <kezal_at_mail.ru>
Date: Wed, 13 Jun 2001 10:49:49 +0400
Message-ID: <3B270D0D.851EC2A1@mail.ru>

Hello Ali!

 alter table xxx add (newcol ...);
 update table xxx set newcol=oldcol;
 alter table xxx drop column oldcol;

Ali Galewski wrote:

> How do you rename a column in a table?

Rgds, Vadim Grepan

---

Moscow, Russia Received on Wed Jun 13 2001 - 01:49:49 CDT