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

Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming a column

Re: Renaming a column

From: Malcolm Turner <mal_at_wcs.dnet.co.uk>
Date: Tue, 25 Aug 1998 13:51:55 GMT
Message-ID: <35e6b95f.77403703@news2.dnet.co.uk>


>On Sat, 22 Aug 1998 22:36:28 -0500, Lak Nadella
><lak_at_more.net> wrote:
>
>>Could someone give me pointers as to how I can rename a column in a
>>table without dropping the table and recreating it?
>



Provided that the column isn't a key column, you can change col$ using

the object obj# from obj$.
Note - this is TOTALLY unsupported, but it works. Received on Tue Aug 25 1998 - 08:51:55 CDT

Original text of this message

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