Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

primary key

Status
Not open for further replies.
alex12

alex12

ISP
Oct 6, 2004
14
GB
To create a relationship between tables without primary keys set up, what would I do? And how what I use unique keys to create relationship?
Thanks.
 
Sort by date Sort by votes
You don't need to use the primary key to setup a relationship between tables. It is just the easiest way to do it.

Simply create the relationship like you would with a primary key.

Denny

--Anything is possible. All it takes is a little research. (Me)

[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Conditional Foreign Key Constraint
Replies
1
Views
240
Chris Miller
Chris Miller
BTrees
  • Locked
  • Question
Incremental Load (No primary key) 2
Replies
2
Views
209
Olaf Doschke
Olaf Doschke
craigward
  • Locked
  • Question
Cross table insert duplicate key issue 1
Replies
7
Views
195
Olaf Doschke
Olaf Doschke
JoPaBC
  • Locked
  • Question
Incorrect syntax near the keyword 'GROUP' 1
Replies
2
Views
579
JoPaBC
JoPaBC
BxWill
  • Locked
  • Question
TSQL - Bulk Insert - Composite Primary Keys - Cannot insert the value NULL into column 2
Replies
6
Views
166
BxWill
BxWill

Part and Inventory Search

Sponsor

Back
Top