Home » Developer & Programmer » Designer » Renaming Columns (Oracle 10g Designer)
Renaming Columns [message #519046] Tue, 09 August 2011 02:06 Go to next message
tabishimam
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,
Tabish

Report message to a moderator

Re: Renaming Columns [message #522165 is a reply to message #519046] Wed, 07 September 2011 01:44 Go to previous message
Baranor
Messages: 83
Registered: September 2011
Location: Netherlands
Member
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.

Regards,

Barry

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 02 02:40:03 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.