Foreign Key Finding 'Owner'

Hi,

I have specified a Foreign key with a table of my database.

Now I need to, with an SQL Query, be able to tell which table holds the
Primary Key and what the Field Name?

In Other Words:

-----------------
tbl_Computer
-----------------
PK | ComputerID
FK | TheAddONID

-----------
tbl_AddOn
-----------
PK | AddOnID


Link/Constraint: TheAddONID = AddOnID

I would like an SQL procedure that could tell me the table and column I am looking for is:

Table = tblAddOn
Column = AddOnID