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

Toad Data Modeler
1

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

2

Hello,

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

Thanks.

Regards,

Vladka

3

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

4

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

5

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