How can I configure SSMA to generate a filtered Unique index that ignores NULL?

114 Views Asked by At

My business logic relies on the Oracle feature that NULL is ignored in a Unique index.

How can I configure SSMA to automatically generate a filtered Unique index that ignores NULL?

Manually, in T-SQL, I could write

CREATE UNIQUE INDEX indunique ON mytable(uuid)  WHERE uuid IS NOT NULL
0

There are 0 best solutions below