SQL Server Script to show all FK relationships in the current database

showRelationships.sql

	SELECT
		fk.name 'FK Name',
		tp.name 'Parent table',
		cp.name, cp.column_id,
		tr.name 'Referenced table',
		cr.name, cr.column_id
	FROM 
		sys.foreign_keys fk
	INNER JOIN 
		sys.tables tp ON fk.parent_object_id = tp.object_id
	INNER JOIN 
		sys.tables tr ON fk.referenced_object_id = tr.object_id
	INNER JOIN 
		sys.foreign_key_columns fkc ON fkc.constraint_object_id = fk.object_id
	INNER JOIN 
		sys.columns cp ON fkc.parent_column_id = cp.column_id AND fkc.parent_object_id = cp.object_id
	INNER JOIN 
		sys.columns cr ON fkc.referenced_column_id = cr.column_id AND fkc.referenced_object_id = cr.object_id
	ORDER BY
		tp.name, cp.column_id

Just what I needed. Thx!! (small typo 'Refrenced')

just what I was looking for!!! thank you so much for sharing!!!!

thanks!