Table Relationships
Relationships Without Foreign Keys
Investigate logical table relationships when explicit foreign-key constraints are missing or incomplete.
Steps
1
Search metadata and documentation
Look for compatible identifiers, descriptions, unique keys, and established business keys.
2
Review trusted SQL
Inspect views, stored procedures, reports, and integrations for established join conditions.
3
Validate with data
Check duplicate parent values, unmatched child values, and expected cardinality.
4
Add the reviewed connection
Store the confirmed logical relationship in the SQL Mocker workspace.
Learn more
Guide: Find relationships without foreign keysOpen the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.