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