Re: Designer 2000 - Reverse Engineering

I did same thing. I reverse engineered and did table to entity retrofit. It did not order of the columns. It just displays in E-R diagram in alphabetic order. If you create table from the entity, it will create in same original sequence.

However, I notice some other problem. When I used retrofit tables to entities, it changed name of all foreign keys to system generated name as name of the primary column in reference table appended with constraint id.

In article <1995Nov15.224454.7174_at_venus.gov.bc.ca> gary.wong_at_cyberstore.ca writes:
>> nvtuan_at_deepthnk.kiwi.gen.nz (Tuan Nguyen) writes:
>> I have managed to reverse engineer the tables from an existing Oracle 7
>> database. But when I tried to retrofit the tables to entities, the attributes
>> in the entities appear in alphabetical order, not the physical sequence of
>> the columns in the tables. Does anyone know how to get around this, short of
>> going through every attributes and rekeying in the sequence numbers - which
>> are present in the columns in the tables!!!
>>
>> -- Tuan
>>
>>>>>
>Tuan,
>
>Oracle's view is that the physical sequence of the columns has no relevance at the logical model level. In other words, modelling the
>information requirements *shouldn't* require having the attributes in any particular order.
>
>I'm not sure if I agree 100%, but I do see some validity in what they're saying; If there is another reason why Oracle didn't include this in
>the 'retrofit utility' or if they plan to change this in future releases, please post it...
>
>Regards,
>Gary Wong (gary.wong_at_cyberstore.ca)
Received on Tue Nov 21 1995 - 00:00:00 CET