SQL Server 2012 Visualization of Table relationships
In SQL Server Management Studio, you can create Database Diagrams with the relationships on tables. 
This is per database, and not on the Instance level.

Microsoft Reference