Find All Primary Keys and The Tables They Are Associated With

I previously posted about finding user table basic information. In this post, let us use a handy TSQL to find all the Primary Key Constraints and the tables they are associated with.