How can we help you today? How can we help you today?

Multiple columns as unique

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
dineshasanka
0

Comments

3 comments

Sort by
  • 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
    benhall
    0
  • dineshasanka
    Yes that is exactly what I meant
    dineshasanka
    0
  • 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.
    gvsoft
    0

Add comment

Please sign in to leave a comment.