Is there any way that I can find out what tables uses columns from another table as their thier foreign keys?(i.e. is primary key foreign key relation ship)

Can anybody paste a script that does that?