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 |
|
npstr
Starting Member
1 Post |
 Posted - 2006-03-26 : 05:19:26
|
| hello all,I am new to SQL server and dont have a clue on how to create a one-to-one relationshipin sql server2000. Say, I have a table 'A' with a PK <customer_id> and another table 'B' with a PK <order_id>. Now to define a one-to-one relation between them how to do that?thanks in advance.-tanveer |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-26 : 05:22:47
|
| http://www.utexas.edu/its/windows/database/datamodeling/dm/erintro.htmlread the entire article-ec |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-03-26 : 08:25:35
|
| I would advice you get a bookhttp://www.sqlteam.com/store.asp |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-26 : 15:48:20
|
quote:
Originally posted by npstr
hello all,I am new to SQL server and dont have a clue on how to create a one-to-one relationshipin sql server2000. Say, I have a table 'A' with a PK <customer_id> and another table 'B' with a PK <order_id>. Now to define a one-to-one relation between them how to do that?thanks in advance.-tanveer
More than likely, you would not want a one-to-one relationship.It is likely that a customer would have more than one order, so it is most likely that you would want a one to many relationsship.CODO ERGO SUM |
|
|
|
|
|
|
How to create a one-to-one relationship