Model Verification Detail Settings

Toad Data Modeler
1

Hi,

May I suggest renaming the check boxes to clarify their meaning.
Each check box seems to turn on a check so better names for the last two would be;

  • Check Duplicate Constraint Names
  • Check Duplicate Key and Index Names

Also I have tried creating duplicate key names (both in different entities and the same entity) but they don’t seem to be reported in Model Verification.

Regards
Malcolm

2

Hello,

Thanks for your suggestion. We will consider it. CR # 47 709. We will either remove 'Check' or will add 'Check' to all items. (In this case, the last item would be Check Disallowed Duplicate Key and Index Names. Well, it may sound strange. Possibly, we do not use English properly here. However, in other words, we want to say that Duplicate Keys and Index names that are not allowed should be checked. (I've consulted it with our developers. The word 'permitted' is not good, 'disallowed' seems to be more accurate in the meaning. In any case, if you have any better suggestion, we would appreciate it. Thanks.)

Also I have tried creating duplicate key names (both in different entities and the same entity) but they don't seem to be reported in Model Verification.

During verification, empty keys are not verified. In fact, if a key is empty, it does not exist in the model and is not generated. Therefore, it is not verified either.
However, if you create a duplicate key name, you are warned.
If duplicate key names with attributes exist, errors are returned during the model verification.

If you have any questions, please write me back. Thanks.

Regards,

Vladka + TDM Team

3

Hi Vladka,

The word 'permitted' is not good, 'disallowed' seems to be more accurate in the meaning. In any case, if you have any better suggestion, we would appreciate it.

Can you tell me what conditions make them "disallowed"? Then I'll see if I can think of a different word to use.

Thanks
Malcolm

4

Hello Malcolm,

Here I’m with an explanation on option Check Disallowed Duplicate Key and Index Names.

If there is a key and an index of the same name defined for the same attributes, it is not considered as duplicity.
BUT
If there is a key and an index of the same name defined for different attributes, it is considered as duplicity and the verification will return the error message.

Regards,

Vladka + Mario

5

Hi Vladka,
I think we would use terms such as “invalid” or “illegal” rather than “disallowed”.
Kind regards
Malcolm

6

Thanks for your suggestions.
(Sometimes it’s pretty hard for us - non English speakers - to find the right expression… :slight_smile: Thanks again for your help!)

Regards,

Vladka