Here is a link to a script I submitted that will find all foreign keys:
http://www.sqlservercentral.com/scripts/foreign+keys/64333/
It wouldn't be too hard to extend it using sys.index_columns and sys.indexes
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question