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 sorting options that you specify on the Filters and Sorting page are applied automatically when you create new diagrams.
The workbench offers five sorting options for compartment items:
Show physical order (non-key), primary key order (key)
  • Non-key attributes of an entity display on the diagram in the same order that they display on the Attributes tab of the Properties view of the entity.
  • Non-key columns of a table display on the diagram in the same order that they display on the Columns tab of the Properties view of the table.
  • Key constraint members display in the same order that they display on the Members tab of the Properties view of the primary key object.
  • Key attributes display in the same order that they display 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 display on the diagram in the same order that they display on the Attributes tab of the Properties view of the entity.
  • Key and non-key columns display on the diagram in the same order that they display 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