Renaming Columns [message #519046] |
Tue, 09 August 2011 02:06 |
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
|
|
|