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?
/Anders
Unfortunately no, there is no way to add such custom SQL for creating extra objects.