dependency on columns basis

Hello,

I have a lookup table I want to delete  which is referenced as a foreign key in another table.  Is there is a way to find all of the  tables depends on this column (foreign key) but not the whole table or view.


Thanks in advance