Indexes for Foreign Keys not automatically renamed in the data model.
Steps: to reproduce issue:
1. Create Entity 1.
2. Create Entity 2.
3. Create Foreign Key (FK) between Entity 1 and Entity 2.
4. Index is automatically created and named as IX_<Relationship>.
5. Rename FK.
6.The Index is not renamed automatically.
In version 5.2 FK Index was only a relationship property which was generated but not part of the model itself.
In version 5.3. FK index was implemented as an object. This allows users to see FK Indexes in Entity SQL Preview, define more settings for these Indexes (previously only name change was possible), e.g. Indexes in Entity Properties, Model Explorer and Designer.
New features will be implemented in future Toad Data Modeler releases i.e. keeping the same FK index name as name of relation (with prefix).
WORKAROUND
None.
STATUS
Waiting for fix in a future release of Toad Data Modeler.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center