How to find a foreignKey tablename and column name by inputting the primary key tablename and column name?

[vijay joshi]

Hi,
i want to find out foreign key columns along with their table name
by giving the input as table name and primary key column name.

Suppose, student(T) is having a primary key as student_id,
and now this key is shared among different tables as a foreign key such as
Identity (T), Passport (T), Student_Courses(T).

so i want to find out how to write the query for achieving the above result?

i want to get the result in following format :
Table_Name, Foreign_key_Column

Please guide me in this regard.

Thanks In Advance.