s there a way to use Redgate to identify possible table relationships.
Drw001 Posts: 3 New member
I inherited a legacy database with several table with primary keys but no foreign key relationships. Is there a way to use Redgate to identify possible table relationships.
0 · Share on Twitter
You could focus on most resource consuming queries first allowing you to quickly solve the most pressing issues?
Thank you for reaching out on the Redgate forums regarding this relationship query.
It may be a hard one to define a specific method to find the possible relationships.
With your legacy database, is there any specific logic that would be used to determine if a relationship should exist. Matching object name/data type for instance?
It may be possible to script it to output all the table columns to work through and look for matches.
I tested this by running the script, output the result to Excel and highlighting duplicate column_names. Gave me a starting point to look for possible relationships.