Sorting properties

Use the Sorting page of the Properties view of the diagram to specify how items are sorted on the diagram.
Note: You can set the default preferences for these properties in the Preferences window by expanding the Data Management node: Diagram > Filters and Sorting.
The workbench offers five sorting options for compartment items:
Show physical order (non-key), primary key order (key)
  • Non-key attributes of an entity appear on the diagram in the same order that they appear on the Attributes tab of the Properties view of the entity.
  • Non-key columns of a table appear on the diagram in the same order that they appear on the Columns tab of the Properties view of the table.
  • Key constraint members appear in the same order that they appear on the Members tab of the Properties view of the primary key object.
  • Key attributes appear in the same order that they appear on the Key Attributes tab of the Properties view of the primary key object.
Show physical order (all attributes) or Show physical order (all columns)
  • Key and non-key attributes appear on the diagram in the same order that they appear on the Attributes tab of the Properties view of the entity.
  • Key and non-key columns appear on the diagram in the same order that they appear on the Columns tab of the Properties view of the table.
Sort alphabetically (ascending)
Compartment items are sorted in ascending alphabetical order (A-Z).
Sort alphabetically (descending)
Compartment items are sorted in descending alphabetical order (Z-A).
Sort by data type
Compartment items in an entity or table are sorted based on data type, in ascending alphabetical order (A-Z).

Feedback