Re: rename a column?

From: Tim Hall <tim.hall_at_tswi.spambuster.com>
Date: 1997/09/05
Message-ID: <340fbbbc.490920@69.0.9.9>#1/1

On Thu, 04 Sep 1997 17:59:31 -0700, Tom La Porte <tlaporte_at_dreamworks.com> wrote:

>Is there any way to rename a column, other than recreating the table?
>
>The ALTER TABLE command allows you to change constraints and
>data types on a column, but doesn't seem to allow a name change.
>
>It's not a crucial issue, but I couldn't find anything in my brief
>search of the Oracle docs. Just wondering if I missed something obvious.
>
>Any suggestions are appreciated.
>

No, you can't. The only way is to recreate the table, as you feared. This is a real pain.

---

Tim Hall, TSW International, Now Indus International

http://www.tswi.com
http://www.indusgroup.com

Remove "spambuster" from email address before replying Received on Fri Sep 05 1997 - 00:00:00 CDT