Troubleshooting
Incorrect Relationship Suggestions
Correct or remove a suggested table connection that does not match the database's business logic.
Steps
1
Do not confirm automatically
Suggested connections are candidates and require user review.
2
Compare identifiers and grain
Check data types, uniqueness, nulls, table grain, and composite keys.
3
Edit or remove the connection
Use Relationships Overview and Properties to correct endpoints or delete the suggestion.
4
Confirm only verified relationships
Use documentation, trusted SQL, and domain knowledge as evidence.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.