Table Relationships
Define Table Relationships
Review connections already available from database metadata and add additional relationships when the schema does not fully describe how tables connect.
Steps
1
Open Relationships Overview
Start from a reviewed schema and inspect its existing connection map.
2
Keep confirmed metadata
Use primary-key and foreign-key relationships already supplied by the database where they are correct.
3
Complete missing context
Add only additional connections you can verify from documentation, existing SQL, data checks, or business knowledge.
4
Confirm the map
Save the reviewed relationship context to the SQL Mocker workspace for SQL generation.
Learn more
Guide: Relationships without foreign keysOpen the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.