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

Home -> Community -> Usenet -> c.d.o.misc -> Changing a column

Changing a column

From: Sbaiz <pierluigi.sbaiz_at_elsag.it>
Date: 1998/04/21
Message-ID: <01bd6cf2$08708840$b8cd5997@sbaiz>#1/1

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 Tue Apr 21 1998 - 00:00:00 CDT

Original text of this message

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