Home » Developer & Programmer » Designer » Renaming Columns (Oracle 10g Designer)
Renaming Columns [message #519046] Tue, 09 August 2011 02:06 Go to previous 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,
Read Message
Read Message
Previous Topic: Best Practice for Data Modelling
Next Topic: copy component
Goto Forum:

Current Time: Sat Sep 19 01:16:17 CDT 2020