Red Gate forums :: View topic - Multiple columns as unique
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Multiple columns as unique

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dineshasanka



Joined: 11 Jul 2005
Posts: 166
Location: Colombo Sri Lanka

PostPosted: Wed Apr 16, 2008 1:33 pm    Post subject: Multiple columns as unique Reply with quote

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
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger MSN Messenger
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Wed Apr 16, 2008 2:53 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
dineshasanka



Joined: 11 Jul 2005
Posts: 166
Location: Colombo Sri Lanka

PostPosted: Thu Apr 17, 2008 6:11 am    Post subject: Reply with quote

Yes that is exactly what I meant
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger MSN Messenger
gvsoft



Joined: 19 Jul 2012
Posts: 16

PostPosted: Mon Oct 01, 2012 11:03 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group