|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi guys i wonder if i can add one to one reletionship between 2 tables in sql server 2000 just like access 2000. I be happy if some one teach me how. IN the links below is the pics of my tables.I want to add one to one reletionship between players table and teams.Thanks
http://i5.photobucket.com/albums/y1...eletionship.jpg http://i5.photobucket.com/albums/y1...eletionshp2.jpg |
|
#2
|
|||
|
|||
|
I think what you want is a unique constraint (or index) on the PlayerNo field in the Teams table. Once you apply that change you should see the relationship change to a one-to-one relationship.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > how to addd one to one reletionship between 2 table ? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|