A query tool could assist creating joins for you based on these
See Books Online, "Foreign Key". When you "draw" such line, you create a
foreign key constraint. That prohibit you from entering a value in the
"child" table unless there exist a row with that value in the "parent"
table, loosely speaking.
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.
> I am new to using SQL Server....If I am creating a database diagram and
> create relationships between tables by dragging and dropping the relating
> fields from one table to another, what does this give me other than a
> indication of how the tables are related? IOW, how does SQL Server use
> relationship information? If I am writing my own query, I would specfy the
> join conditions myself...Does SQL Server make use of these automatically