Use this script to get relationship between ur tables (PK, FK), if defined. This script will give you base table and its columns (PK) with other related tables and columns (FK).
So, no need to check in the diagram.
MCP, MCAD (.Net), MCSD, MCDBA
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.