Multiple columns as unique

[dineshasanka]

There is no way that you can specify multiple columns as unique. However, if you can define this unique key constraint from the database end, data generator tool will treat multiple columns in the unique key constraints and generate data accordingly. For example, if I need to set both FirstName and LastName as unique constraints there is no way of doing this,unless I create unique key constraint from the database side

[benhall]

Hi Dinesh,

Thank you, it's an interesting idea. If I understand you correctly, you want to manually specify a multi-column unique constraint via the UI?

In the database it would be something like this:
CREATE UNIQUE NONCLUSTERED INDEX [NC_Relationship11_TwoUniqueConstraints1] ON [dbo].[Relationship11_TwoUniqueConstraints] ([one], [two])

I like the suggestion, I will add it to the list and see what we can do for a future release.

Thanks

Ben

[dineshasanka]

Yes that is exactly what I meant

[gvsoft]

What happened to this requested suggestion? Did it get tossed out? Four years later, version 2.0.3.1 still doesn't have this capability.