Skip to main content
Completed

Excluding multiple NULL values for indexes by default

Related products:Software Factory
  • January 18, 2019
  • 1 reply
  • 81 views

Robert Jan de Nie
Thinkwise blogger
Forum|alt.badge.img+7
In SQL Server, a unique index does not allow multiple NULLs by default. There is a way around this by adding a where clause to the index. (where unique_field is not null). However, this can not be modelled in the SF.

1 reply

Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • January 18, 2019
Unique indexes can now be configured to exclude null values.