Hey,
please take a look at this:
http: // sqlserver2000.databases.aspfaq.com/schema-how-do-i-find-all-the-foreign-keys-in-a-database [dot] html (sorry i cant post links :O
)
This has a bit more than you think you need (bit will probably need to accomplish your task).
regards, Kris