Re: Rename a column

From: Tim Hall <tim.hall_at_spam.begone>
Date: Mon, 20 Apr 1998 13:21:48 GMT
Message-ID: <353b4afd.9432214@69.0.9.9>

On Mon, 20 Apr 1998 21:00:35 +0800, "Lui Yuan Tze" <ssplyt_at_pacific.net.sg> wrote:

>Hi,
>How does one rename a table column ?
>
>Cheers
>

You can't. You have to rename the table, then create a new table with your desired new column in it and copy the data across (You can do this with create table <TABLE> as select * from <OLD_TABLE>)

You will also have to recreate your indexes, keys, constraints etc.

BTW, Message to the Gods of comp.database.oracle.* - Where is the FAQ for this group? Is this question in it, 'cause it comes up rather a lot :)

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 Mon Apr 20 1998 - 08:21:48 CDT