Index definition

I have a field in a table that allows null, and I want an unique index on that table that only should check for uniqueness on non-null values. In MS SQL this is done this way:

create unique nonclustered index myIndex

on myTable( myFieldName )

where myFieldName is not null;

If I set this up in Data Modeler, it generates a script with the standard

create uniqueindex myIndex on myTable(myFieldName)

but this doesn't work. Is there a way to trick DM to do it the right way?


Unfortunately no, there is no way to add such custom SQL for creating extra objects.