I believe the following is what you're looking for:
SELECT OBJECT_NAME(constid), target_table.name AS target_table, target_column.name AS target_column,
source_table.name AS source_table, source_column.name AS source_column
FROM sysforeignkeys fk
INNER JOIN sysobjects target_table ON fk.fkeyid = target_table.id
INNER JOIN syscolumns target_column ON fk.fkeyid = target_column.id AND fk.fkey = target_column.colid
INNER JOIN sysobjects source_table ON fk.rkeyid = source_table.id
INNER JOIN syscolumns source_column ON fk.rkeyid = source_column.id AND fk.rkey = source_column.colid
ORDER BY OBJECT_NAME(constid), target_table.name
Good luck.
Mark
|