Lists all foreign keys (source and ref columns) in a MSSQL database.

mssql_fk_list

SELECT 
	t.name AS TableWithForeignKey,  
	c.name AS ForeignKeyColumn,
	r.name AS ReferencedTable,
	rc.name AS ReferencedColumnName
FROM sys.foreign_key_columns AS fk
	inner join sys.tables AS t ON fk.parent_object_id = t.object_id
	inner join sys.columns AS c ON (t.object_id = c.object_id  AND fk.parent_column_id = c.column_id)
	inner join sys.tables AS r ON fk.referenced_object_id = r.object_id
	inner join sys.columns AS rc ON (r.object_id = rc.object_id AND rc.column_id = fk.referenced_column_id)

ORDER BY 
	TableWithForeignKey, 
	fk.constraint_column_id