Return
-
Title
Is there a visual way to determine if the PK of an entity is clustered? -
Description
SQL Server model:
Is there a visual way to determine if the PK of an entity is clustered?
-
Resolution
Unfortunately, there is no way to visualize cluster/non cluster keys on the diagram.
Toad Data Modeler has 5 colors of attribute and 3 key icons as follows:
Attribute in Primary Key Red Color Red Key Icon Attribute in Primary Foreign Key Blue Color Blue Key Icon Attribute in Foreign Key (non primary) Green Color Green Key Icon Mandatory Attribute Black Color No Icon Optional Attribute Medium Gray Color No Icon To have an option be considered, to distinguish between cluster and non-cluster keys, please visit the Toad Idea Pond where you can make the request, or vote and comment on a request that may already have been placed.