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 -> Renaming a column

Renaming a column

From: <bastien.piroue_at_gsi-office.de>
Date: 1999/01/27
Message-ID: <78meok$biv$1@nnrp1.dejanews.com>#1/1 






Hello,



I want


a) to change the datatype of a column of a table
b) to change the name of a column of a table.



I want this for Oracle7, Oracle8 and MS-SQL-Server 6.5 and MS_SQL - Server 7.
The tables are in use, so that there are rows in it, that the alter table
alter column - command of ORACLE fails. Any tools, suggestions?



Thank you for any help!



Bastien Piroué, Germany



-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Wed Jan 27 1999 - 00:00:00 CST












Original text of this message













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