Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
donnapep
Starting Member
15 Posts |
 Posted - 2007-02-06 : 10:39:33
|
| Hi,I have a table called Release that has a composite primary key of ReleaseID, ProductID.Now, I also have a Sprint table that needs to store the ReleaseID and ProductID columns as well in order to join back to the Release table.My question is this - should I create an identity column to function as the primary key in Release so that I can just store this one field in the Sprint table instead of two columns? Is there a general rule about this?Thx. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-06 : 11:16:38
|
| "Is there a general rule about this?"No "Rule" that I know of, but I've read plenty of "religion" on the subject!Have a hunt for "surrogate keys" to read around the subject.Kristen |
 |
|
|
|
|
|
Composite Foreign Keys