How are columns sorted in the diagrammer?

[Dwayne]

For the life of me I can't figure out how the diagrammer is determining what order to show the columns in.

It's not alphabetical....it's not ordered as the table is....it's not by type...

How can I make the diagram have the columns in the tables shown in the same order as they are defined? i.e. using the value in USER_TAB_COLUMNS.COLUMN_ID

 

[Marco Kalter]

If all is well the columns are sorted by their physical order in the table (order by column_id). The same order as when you do a describe.

 

[Dwayne]

That's definitely not the behavior I'm seeing. I'll upload two images showing how the diagrammer and the table structure differ.

 

[Bernhard S]

If you create a new diagram it's sorted by column ID, however if you update from database any new columns get added at the end of the existing tables, even though in the database they are added somewhere in the middle. I find this annoying too. The resulting order in the PSD diagram should be always in the order of column IDs, no matter what.

 

[Marco Kalter]

We'll fix it!

 

[Dwayne]

Ahhhhh....now that sounds more like what I'm experiencing.

Thanks for the input. Looking forward to the fix, since the only way to resolve is to recreate the diagram

 

[Bernhard S]

This is still not fixed in PSD v9.0.0.1601