Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming a column
Hi!
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!
>
Use CASE tools for keeping DB model. They generate SQL scripts for DB modification including constraints dropping and creating if needed etc.
We use Sybase PowerDisigner 6.1 and one works fine.
Bye! Received on Thu Jan 28 1999 - 00:00:00 CST