Skip to main content
Completed

Excluding multiple NULL values for indexes by default

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

Robert Jan de Nie
Thinkwise blogger
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.
Did this topic help you find an answer to your question?

1 reply

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

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings