See all the tables that have foreign keys to a certain column in a table?

Question

Is this possible ? If yes, what are the tables involved, somewhere to look into .

Answer 1

Try something like this

select uc.table_name 
from sys.user_cons_columns ucc
join sys.user_constraints uc 
on uc.r_constraint_name = ucc.constraint_name
where constraint_type = 'R'
and ucc.table_name = :1
and ucc.column_name = :2

where

:1 = referenced table
:2 = referenced column