[EMPIREDB-303] Add support for Unique-Indexes which allow null values

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: empire-db-2.5.0
• Component/s: Core
• Assignee: Rainer Döbele
• Reporter: Rainer Döbele
• Created: 10/Sep/19 12:08
• Updated: 13/Jan/22 15:07
• Resolved: 04/May/20 10:55

Description

Databases might support Unique-Indexes that allow Null values.

In SQL-Server the Syntax is like:

CREATE UNIQUE INDEX SOMECOLUMN_IDX ON SOMETABLE (SOMECOLUMN) WHERE SOMECOLUMN IS NOT NULL