Toad World® Forums

Impossible to create alternate key with 2 fields when 1 field must be null

When we create Alternate key with 2 fields (1 field is NOT NULL and second is NULL) - TOAD Data Modeler automatically sets field that was nullable to NOT NULL and grays it. We can’t update that field to reqiured state - it must be optional (NULL).
So TOAD sets ALL fields in Alternate Key as NOT NULL.

TOAD Data Modeler 3.4.16.7
DB: MS SQL 2005

Hello,

Unfortunately, it is not possible.
We will see what we can do about it. CR # 60 580.

Thanks.

Regards,

Vladka

seeing that in version 6.0.3 what is the process to allow nulls

Hello,

by default is disallowed set null attributes in keys. If you want this, you need go to Main Menu - Settings - Options - Physical Model - General tab and set option “Allow Null Attributes in Keys”.

Daril

Hi,

the availability of this option differs by database. Please see the topic Models and Model Objects > Physical Data Model > Basic Database Design > Create Keys in the help.

Regards

Dave