What are the challenges you face when working across database platforms? Take the survey
Options

Multiple columns as unique

dineshasankadineshasanka Posts: 208
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

Comments

  • Options
    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
  • Options
    Yes that is exactly what I meant
  • Options
    gvsoftgvsoft Posts: 20 Bronze 1
    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.
Sign In or Register to comment.