The Ultimate Foreign Key Researcher

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jesse Roberge » The Ultimate Foreign Key Researcher

The Ultimate Foreign Key Researcher

Rate Topic

Display Mode

Topic Options

Author

Message

YeshuaAgapao

Posted Saturday, June 21, 2008 10:29 AM

Say Hey Kid

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:17 PM
Points: 701, Visits: 207

Comments posted to this topic are about the item The Ultimate Foreign Key Researcher

Post #521269

RHale

Posted Tuesday, September 28, 2010 12:54 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, March 17, 2011 1:47 PM
Points: 50, Visits: 7

Does 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.

============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493

Post #994747

YeshuaAgapao

Posted Tuesday, September 28, 2010 2:00 PM

Say Hey Kid

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:17 PM
Points: 701, Visits: 207

If @PkTable, @PKSchema (provide if not dbo), or @PkColumn are not existing values, the proc will return no results.

Post #994779

« Prev Topic | Next Topic »

Permissions