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?



/Anders

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