Not all join conditions may be foreign key relationships. How do you know a table has to be parent table / a column should be a foreign key? Do you use same column names? is there any naming convention followed? if yes, then we can explore to query meta data tables ( sys.columns etc ) to know which are potential foreign key candidates.