Table Relationships
Investigate and Add a Missing Relationship
Use Investigate Relationships to find, validate, and confirm possible table connections when database metadata is incomplete.
Steps
Open Relationships Overview
Review the relationships already defined in the imported database metadata and identify tables that remain disconnected.
Start Investigate Relationships
Select Investigate Relationships. The tables in Relationships Overview are preloaded into the investigation.
Run the Investigation SQL
Generate the database-specific investigation script, review and run it in your own database tool, then paste the results or upload a supported results file.
Analyse candidate relationships
Select Analyse Results. Database-defined relationships remain separate from evidence-based Candidate Relationships, which show the proposed source and parent columns with their structural evidence.
Run optional further data validation
Choose Select for data validation for one or more candidates, then select Run Further Data Validation Checks. Run the generated aggregate script and return the results. Outcomes appear under Updated candidate relationships without changing the original structural candidate list.
Confirm or reject each suggestion
Select Confirm suggested relationship only when the evidence matches your understanding of the schema, or select Reject when it does not. Confirmed suggestions are added to the SQL Mocker workspace as user-confirmed discovered relationships.
Add a connection manually when needed
If the investigation does not identify the required connection, return to Relationships Overview, select Add relationship, and connect the verified source and target columns manually.
Learn more
Guide: Find relationships without foreign keysOpen the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.