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

Re: Renaming a column

From: Leonid Popov <ply_at_chat.ru>
Date: 1999/01/28
Message-ID: <36b03b9d.0@128.1.5.14>#1/1

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

Original text of this message

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