Viewing table relationships in SQL Server Management Studio

Solution 1:

If you are using Management Studio 2008 :

Expand the root Database, try and expand the Database Diagrams folder, it should say something like "no diagrams".

If it asks you to create a diagram say yes, then add the tables and voila!

If not, right on Database Diagrams folder and create new Diagram.

Solution 2:

Try out ApexSQL Search

ApexSQL Search is a FREE SQL Server Management Studio and Visual Studio add-in that, among other features, has the View Dependencies feature. The View Dependencies feature has the ability to visualize all SQL database objects’ relationships, including those between encrypted and system objects, SQL server 2012 specific objects, and objects stored in databases encrypted with Transparent Data Encryption (TDE)

The View Dependencies feature also allows you to set up and customize the visual dependencies diagram layout, including the relationships that will be presented, the layout and size of the generated diagram, and the drill-down depth of the dependencies

Solution 3:

If you want to display dependencies for specific table just select your table and right-click View Dependencies. Check how to view dependencies.

SQL Server 2005 lets you display dependencies like this

SELECT OBJECT_NAME(object_id) referencing,
  OBJECT_NAME(referenced_major_id),
  *
FROM sys.sql_dependencies 

SQL Server 2008 has sys.sql_expression_dependencies follow this link