Home » Developer & Programmer » Designer » Renaming Columns (Oracle 10g Designer)
Renaming Columns [message #519046] Tue, 09 August 2011 02:06 Go to next message
Messages: 5
Registered: August 2010
Junior Member

I am trying to rename a column in an existing ERD.
After renaming the column in the attributes section of the ERD i run the database design transformer (allowing for column modifications).
When i try to generate the DDL script for this change. I am prompted to drop the previous column (subsequently a new column is added).

I dont wish to have this script. Rather i wish to have the format: Alter table <tablename> rename column <oldcolumnname> to <newcolumnname>.

Is there any way i can achieve this in Oracle Designer 10g

thanks and regards,
Re: Renaming Columns [message #522165 is a reply to message #519046] Wed, 07 September 2011 01:44 Go to previous message
Messages: 83
Registered: September 2011
Location: Netherlands
Hey Tabish,

As far as I recall the influence you have on such scripts is limited. Are you doing a mass-rework or just a few columns? If its not too many I'd go with making a quick macro and doing in that way. If its a whole load ( i.e 500+ ) writing a small script to convert the text file is also an option.


Previous Topic: Best Practice for Data Modelling
Next Topic: copy component
Goto Forum:

Current Time: Sun Mar 03 19:14:30 CST 2024