Retrieving table hierarchy

Anyone has a way to retrieve the complete hierarchy of tables, starting with a parent table?

Table A is the first level. Table B is the child of table A, a foreign key on table B referencing table A, the FK column being part of the PK constraint on table B. Table C is the child of table B, grandchild of table A, the FK column being part of the PK constraint on table C... And so on.

I need to locate the complete hierarchical tree...  Column name can't be used as it is changed when imported from table to table...