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: Changing a column

Re: Changing a column

From: Dave O'Keeffe <DOKeeffe_at_n0spam.cableinet.co.uk>
Date: Tue, 21 Apr 1998 21:20:41 +0100
Message-ID: <353CFF99.2B94@n0spam.cableinet.co.uk>


Sbaiz wrote:
>
> Hi to all
> is there a way, in Oracle, to modifiy a column name without dropping the
> table
> maintaining its data. I know that others databases permit changing the name
> of
> the column or dropping a column, but Oracle not.
> It would be nice if Oracle can modify the column name or generate the
> scripts
> by itself, taking care of all the constraints.
>
> Thanks in advance.
> Pierluigi S.

There is a thread called "Rename a column" dealing with this issue. If you just search for the name you should find it. Dave O'Keeffe
--
For email replys remove "n0spam." from the above address Received on Tue Apr 21 1998 - 15:20:41 CDT

Original text of this message

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