For a given table in an SQL Server, if for a given foreign key column we want to see the referenced table and column using SQL Server Management Studio:

In SQL Server Management Studio, open the table and expand the table where the foreign key resides. For example, in my case, I opened the EmployeeTerritories table and expanded the table:

Next, expand the Keys section.

Now double click the foreign key for which you want the details. A pop-ip dialogue will open. In the dialogue window, you will be able to see the Tables and Columns Specification. Expand this section and it will show the referenced column and table.

This way, you can see the referenced column’s table and column value in SQL Server Management Studio.