This URL even helps determine the columns involved in that Foreign Key.

http://sqlserver2000.databases.aspfaq.com/schema-how-do-i-find-all-the-foreign-keys-in-a-database.html