Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Natural Keys
Message
 
To
09/03/2015 14:40:13
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01616073
Message ID:
01616572
Views:
37
>While on the topic, a similar questions. Are people adding a separate Primary key to many to many join tables or using the two Foreign key fields as that purpose?

I've done both. However, a lot of the basic classes I use tend to expect a single field primary key so I normally just add one to keep things consistent, then add a contraint + index on the two other fields.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform