SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Jesse Roberge / The Ultimate Foreign Key Researcher / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 05:51:58 GMT20RE: The Ultimate Foreign Key Researcherhttp://www.sqlservercentral.com/Forums/Topic521269-1320-1.aspxIf @PkTable, @PKSchema (provide if not dbo), or @PkColumn are not existing values, the proc will return no results.Tue, 28 Sep 2010 14:00:47 GMTYeshuaAgapaoRE: The Ultimate Foreign Key Researcherhttp://www.sqlservercentral.com/Forums/Topic521269-1320-1.aspxDoes this script work for anyone? I get a zero result set when I know that I am using a table with assummed but not materialized foriegn key relationships by the column with the same name as the foreign key.Tue, 28 Sep 2010 12:54:05 GMTRHaleThe Ultimate Foreign Key Researcherhttp://www.sqlservercentral.com/Forums/Topic521269-1320-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/63509/">The Ultimate Foreign Key Researcher</A>[/B]Sat, 21 Jun 2008 10:29:40 GMTYeshuaAgapao