Toad World® Forums

Auto-label relationship lines without programming?

I would love to be able to auto-label the relationship lines with the parent column and/or child column name. As far as I know, the only way to do this is programmatically / via a macro, correct?

Hi,

yes, if you want to use column names then the only method is via custom macro. There can be one small risk when using column names. If your keys included multiple columns then the name of the relationship would be longer than database permits.

In case you decide to use just table names, you have two possibilities:

  1. Change settings of Default Values (TDM must be restarted after you confirm changes in Default Values form.)

When you create new relationship, the name will contain both parent table and child table names. Disadvantage is that in case you rename a table, the relationship name will not be changed automatically.

  1. You can use the Rename Relationship macro.

macro.png

And if you want to make changes, click the Show Code link.

Good Luck!

Vaclav