arr.nagaraj (10/13/2015)
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.
Yes, I know, not all joins could be FK, but if it finds such joining used in between tables, we can ignore upon our choice similar to those indexes which sometimes are not valid and we ignore them... In general if ther is any? Let me update, if you have its solution working?