I want to add some columns into the middle of a table but the add column in the diagram tool and in the data project explorer both append the new column at the bottom of the table. I have a 200 element table and I need to handle a source system upgrade where 26 new columns have been inserted into the middle of the table. I cannot find any command to insert a column into the middle of existing columns. Please don't tell me I have to spend a day clicking the column up arrow a thousand times to order my columns.
For ERwin import please note ERwin maintains multiple orderings for its columns: the logical order (as it appears in the UI in the logical view), the physical order (as it appears in the UI in the physical view), and the database order (as generated in SQL).
These three orderings can be different, and the import bridge uses the ordering in the following precedence: the database order, the physical order, and lastly the logical order. To see the database order, please uncheck the "Physical -> Display Order -> Physical Order" flag in the Stored Displays properties.
I have same problem with mixed columns order after importing data model from ERwin file.
Is there any way to prevent this to happen, either during ERwin export to XML or IDA import steps?
In the end I appended the columns to the bottom of the table in the project explorer or diagram and then re-opened the model as a text file and copied and pasted the fields. This took less manual work but was a long way around a simple requirement. The interface is not very friendly for adding columns.
regards
Vincent McBurney
Tags
Use the search field to
find all types of content in My developerWorks with that tag.
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular type of content or application that you're viewing.
My tags shows your tags for this particular type of content or application that
you're viewing.
