Get table name by foreign key

For example I have a two tables in the database. First table has a foreign key to second table. Can i get second table name by the foreign key from first table?

Thank you.