I am using Designer to generate an ERD and the create scripts for a new set of database objects.
I have ordered the attributes in the Entities, but cannot figure out how to order the columns on the tables similarly without a lot of manual work. The current order places my PK's in the middle of the rows in some cases.
Within the table definitions in Designer
there is are column properties for each column.
The "sequence in table" is the ordering for the columns.
When selecting all collumns of 1 table and display the properties in spreadsheet-mode, you can easaly edit them