I like to know, whether it's possible to get relation-informations from a database, how a table is joined (semantically) with another.
Example (* indicating primary key):
orders: order_id *, order_date, ...
order_items: order_id, line_item_id, product_id, ...
product_information: product_id*...