Re: alter table command

From: Tim Hall <tim.hall_at_spam.begone>
Date: Wed, 29 Apr 1998 12:38:00 GMT
Message-ID: <35471e3c.16094229@69.0.9.9>

On Wed, 29 Apr 1998 12:54:53 +0200, Frank Goebel <Frank.Goebel_at_materna.de> wrote:

>Hi all,
>
>is there a command like >>alter table rename column<< in Oracle and if
>exists, what is the syntax from this command?
>

No there isn't. (Unless you you want to poke around in SYS and invalidate your support contract with Oracle)

The only way to rename a column is to rename the table, create a new table with the correct column name, then copy the data across.

There are some third-party scripts about that help you do this.

Tim Hall, Indus International (was TSW International) tim.hall (at) iint.com
http://www.indusworld.com

Replace domain name with the iint.com before replying via email! Received on Wed Apr 29 1998 - 07:38:00 CDT