Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming a column
Visual Basic 6 (enterprise edition), Data view window will allow you to do this no problem across all these databases. It will even show you the script it uses when its done. You can save it and create your own procedure later. It modifies its methods based on the SQL of the server. Visual Studio will also do this. It's basically the same thing as the data view window in VB.
<bastien.piroue_at_gsi-office.de> wrote in message
news:78meok$biv$1_at_nnrp1.dejanews.com...
>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