Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeffrey Yao Making Good Use of Sysforeignkeys Table - Part 1: Display table relati RE: Making Good Use of Sysforeignkeys Table - Part 1: Display table relati

  • June 1, 2005 at 2:06 pm

    #562352

    Thanks, Robertm, for pointing out the bug. Really appreciate it !

    Sameer, I have replied your email. Pls check it.

    This SP will only display the relationship tree from the top to bottom. So if your table is at on the leaf level of a tree, the SP will only display the table itself.

    In future, I may revise this SP by adding a "switch" control to allow display a "reverse" relationship tree, i.e. from the bottom to top.  

    I am honored if my script can be of any help to SCC community.