Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: RENAME COLUMN

Re: RENAME COLUMN

From: Holger Heidenbluth <holger.heidenbluth_at_keeptool.com>
Date: Thu, 25 Feb 1999 08:46:02 +0100
Message-ID: <36D4FFB9.D4853F58@keeptool.com>


You have to recreate the table with the column renamed, all constraints, triggers, ..., and copy the data into the new table. Our tool Hora can do it for you: generate a SQL script, perform the operation or do both.
Trial copy from http://www.keeptool.com .

Best Regards
Holger Heidenbluth
KeepTool Software, Berlin

RL wrote:

> Hi everybody!
>
> What's the easy way for rename a column in a table ?
>
> Thank's
Received on Thu Feb 25 1999 - 01:46:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US