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: 21 Apr 1998 06:46:13 GMT
Message-ID: <01bd6cf1$f948ae10$b8cd5997@sbaiz> 





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 - 01:46:13 CDT












Original text of this message













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