Toad World® Forums

<%ParentTableName%> <%ParentTableCaption%> for default Relation Attribute Name

Could you please add <%ParentTableName%> <%ParentTableCaption%> application variables for Model | Physical Model -> Relation Attribute Name. Those application variables are already available in Settings | Default Values. Most of the time PKs are named "id" and having FKs named "id" causes errors. Using "<%ParentTableName%>_<%ParentAttributeName%>" would greatly help.


Funny enough it seems that it was supposed to be supported already. See here

Unfortunatelly it does not work on v6.1.3.26.

What is worse is that the behaviour of inserting a non-identifying relationship has changed from v5.3.4.13. Like you, I also have tables where the PK is named simply ID, and when I try to create a FK on the other table, instead of automatcly creating a new column named ID, it tries to map the FK to an existing column. It does not care the column has a different name. It doesn't even care if the column type is not the same. Really, really weird.

Only changing the default option to "always show dialog" helps with this issue, but unfortunatelly it is hindered by the fact that we cannot use <%ParentTableName%> to make Toad create a good column name for us.