# Foreign Key Constraint Names Display

**URL:** <https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761>\
**Category:** Toad Data Modeler\
**Created:** [August 13, 2008, 10:39am UTC](https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761 "2008-08-13T10:39:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![adevereux38](https://avatars.discourse-cdn.com/v4/letter/a/ed8c4c/32.png) [@adevereux38](https://forums.toadworld.com/u/adevereux38)\
**Post date:** [August 13, 2008, 10:39am UTC](https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761/1 "2008-08-13T10:39:18Z")

</div>

Is there a way to toggle the display of foreign key constraint names? Some of the names get to be very long and makes the display very busy. Any help here?

---

<div class="post-metadata">

**Author:** ![vladka](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vladka/32/41_2.png) [@vladka](https://forums.toadworld.com/u/vladka)\
**Post date:** [August 14, 2008, 4:39am UTC](https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761/2 "2008-08-14T04:39:25Z")

</div>

Hello,

I hope you mean names of relationships.  
You can only edit the names but it’s not possible to wrap them.  
You can also define different physical and logical name (caption) and select a physical or logical view then. So, e.g. caption can be shorter and then only caption name can be displayed in logical view.  
Note: Regarding physical name and caption, physical name is just a solid name without any blanks. But in caption, you can divide words and put blanks.

I hope this information will help.  
If you have any questions, please write me back. Thanks.

Regards,

Vladka

---

<div class="post-metadata">

**Author:** ![adevereux38](https://avatars.discourse-cdn.com/v4/letter/a/ed8c4c/32.png) [@adevereux38](https://forums.toadworld.com/u/adevereux38)\
**Post date:** [August 14, 2008, 9:47am UTC](https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761/3 "2008-08-14T09:47:43Z")

</div>

Vladka - Thanks for your response. What I want to do is disable the  
display of the relationship names altogether. In terms of showing a  
developer the relationships between tables, I don’t really need them to  
see the relationship names necessarily. It just makes the display and  
the subsequent print of the model too busy and I spend a lot of time  
unnecessarily moving the names so they are not cluttering up the  
display. Is it possible to have the physical display and not have the  
relationship names appear on the display?

Thanks,

Austin Devereux

This message is intended only for the use of the intended recipient(s)  
If you are not an intended recipient, you are hereby notified that any  
use, dissemination, disclosure or copying of this communication is  
strictly prohibited. If you have received this communication in error  
please destroy all copies of this message and its attachments and notify  
the sender immediately.

---

<div class="post-metadata">

**Author:** ![Vaclav\_Frolik](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vaclav_frolik/32/12_2.png) [@Vaclav\_Frolik](https://forums.toadworld.com/u/Vaclav_Frolik)\
**Post date:** [August 18, 2008, 8:04am UTC](https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761/4 "2008-08-18T08:04:39Z")

</div>

Hi Austin,

if you wish to hide relationship names, right click your workspace and select Workspace Format. New dialog opens. On tab general you can find check box “Display line names”. Uncheck it to hide relationship names.

If you wish to set the settings for all new workspaces, click Settings | Options and click the Physical Model node on the Options dialog. On tab Workspace you can find check box Display Line Names. Uncheck it.

Regards,

Vaclav

---

<div class="post-metadata">

**Author:** ![adevereux38](https://avatars.discourse-cdn.com/v4/letter/a/ed8c4c/32.png) [@adevereux38](https://forums.toadworld.com/u/adevereux38)\
**Post date:** [August 18, 2008, 1:19pm UTC](https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761/5 "2008-08-18T13:19:35Z")

</div>

Man, this is a huge help! Thanks a million!

AD

---

<div class="post-metadata">

**Author:** ![rafaelrsantos87](https://avatars.discourse-cdn.com/v4/letter/r/67e7ee/32.png) [@rafaelrsantos87](https://forums.toadworld.com/u/rafaelrsantos87)\
**Post date:** [July 5, 2013, 12:37pm UTC](https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761/6 "2013-07-05T12:37:24Z")

</div>

Hi all,

i’m using TDM 4.3.4.10.

In the tab View on Display mode, check Caption.

In Relationship properties fill Name and leave Caption blank.

[:D]

---

<div class="post-metadata">

**Author:** ![Vaclav\_Frolik](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vaclav_frolik/32/12_2.png) [@Vaclav\_Frolik](https://forums.toadworld.com/u/Vaclav_Frolik)\
**Post date:** [July 8, 2013, 12:38am UTC](https://forums.toadworld.com/t/foreign-key-constraint-names-display/1761/7 "2013-07-08T00:38:12Z")

</div>

Hi,

The workaround with blank captions would work only in case your display mode was set to Captions. If you switch to Name or FullName, the relationship names will be displayed…

In **Toad Data Modeler version 5.0** , just click the **Hide Captions** icon on toolbar, and the relationship captions/names will disappear!

![hide-captions.png](https://global.discourse-cdn.com/quest/original/2X/6/6fc5d07380c7f0dcc0bd0d57cdbcaae6f45a02c4.png)

Good Luck,
