Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming a column
I know in Oracle 7 you can change the datatype but not the column name which is completely the opposite in SQL server.
As suggested, use the CREATE TABLE AS SELECT in Oracle and SELECT * INTO .. FROM in SQL Server and drop and recreate the table. Also, don't forget the FK constraints that you need to handle if FK exists.
Hope this helps.
Dennis
bastien.piroue_at_gsi-office.de wrote in message
<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