Get list of all the tables and their primary key columns in SQL Server

USE [Northwind]
GO
SELECT sys.indexes.name, OBJECT_NAME(sys.index_columns.object_id), COL_NAME(sys.index_columns.object_id, sys.index_columns.column_id) 
FROM sys.indexes INNER JOIN sys.index_columns ON sys.indexes.object_id = sys.index_columns.object_id 
WHERE sys.indexes.is_primary_key = 1