If you have SQL Server Management Studio, open it up and execute sp_help ‘dbo.TableName‘.
See which column that FK is on, and which column of which table it references. And also that code will let you see many details about Target Table.
You can use the same with shourtcut ALT + F1 as well.
Related posts:
How to check column data types of a table in SQL
How to find the first missing value in a series in MS SQL
Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...
Find numbers with more than two decimal places in SQL
How to clean Query and Execution Plan Cache for Efficient Testing in MS SQL