SQLServerCentral / Discuss Content Posted by Mike Pearon / Article Discussions / Article Discussions by Author / Get the Foreign Key Hierarchy / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 21:16:16 GMT20RE: Get the Foreign Key Hierarchyhttp://www.sqlservercentral.com/Forums/Topic410549-116-1.aspxI think this is a nice foundation script.Mon, 01 Feb 2010 23:29:09 GMTSQLRNNRRE: Get the Foreign Key Hierarchyhttp://www.sqlservercentral.com/Forums/Topic410549-116-1.aspxTable with self references seem to cause an infinite loop in this script. I added "where S1.name <> SO.Name" to the table population query to avoid this.Wed, 27 May 2009 14:53:20 GMTdon.schaefferGet the Foreign Key Hierarchyhttp://www.sqlservercentral.com/Forums/Topic410549-116-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Maintenance+and+Management/30445/">Get the Foreign Key Hierarchy</A>[/B]Sat, 13 Oct 2007 23:42:08 GMTMike Pearson