Re: Changing a column

From: Boi Hue La <boihuel_at_montreal.radio-canada.ca>
Date: Wed, 22 Apr 1998 13:05:01 GMT
Message-ID: <353DEAFC.82AA645@montreal.radio-canada.ca>

In Oracle, it's impossible to modify the column name but you can modify the table name.

Regards

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.
Received on Wed Apr 22 1998 - 08:05:01 CDT