Table relationships
table_relationshipsTrace foreign keys in both directions up to a configurable depth to reveal join paths between tables, eliminating guesswork from column names.
Instructions
Follow foreign keys from one table, in both directions, up to a given depth. Outbound keys tell you what a row points at; inbound keys tell you what points at it. Use this to work out how to join instead of guessing from column names.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| depth | No | How many foreign key hops to follow. Defaults to 2. | |
| table | Yes | Table name, unqualified. | |
| schema | Yes | Schema name. |