Find Relationships Between Tables in SQL Server 2008

find the relationships between tables in SQL Server 2008
  1. SELECT f.name AS ForeignKey,  
  2.    SCHEMA_NAME(f.SCHEMA_ID) SchemaName,  
  3.    OBJECT_NAME(f.parent_object_id) AS TableName,  
  4.    COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName,  
  5.    SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName,  
  6.    OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,  
  7.    COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnName  
  8. FROM sys.foreign_keys AS f  
  9. INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id  
  10. INNER JOIN sys.objects AS o ON o.OBJECT_ID = fc.referenced_object_id