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: . 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).