Lists all foreign keys in an MS SQL Server database

SQL_Server_List_All_Foreign_Keys.sql

-- Lists all foreign keys in an MS SQL Server database
-- Grabbed from here: 
--   http://lostechies.com/jimmybogard/2008/11/27/viewing-all-foreign-key-constraints-in-sql-server/
SELECT
  f.name AS ForeignKey, 
  OBJECT_NAME(f.parent_object_id) AS TableName, 
  COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName, 
  OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName, 
  COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS ReferenceColumnName 
FROM
  sys.foreign_keys AS f 
  INNER JOIN sys.foreign_key_columns AS fc 
        ON f.OBJECT_ID = fc.constraint_object_id