Get the Foreign Key Hierarchy

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 Mike Pearon » Get the Foreign Key Hierarchy

Get the Foreign Key Hierarchy

Rate Topic

Display Mode

Topic Options

Author

Message

Mike Pearson

Posted Saturday, October 13, 2007 11:42 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 04, 2007 4:36 AM
Points: 27, Visits: 1

Comments posted to this topic are about the item Get the Foreign Key Hierarchy

Post #410549

don.schaeffer

Posted Wednesday, May 27, 2009 2:53 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 2:56 PM
Points: 60, Visits: 634

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

Post #724589

SQLRNNR

Posted Monday, February 01, 2010 11:29 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

I think this is a nice foundation script.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #857737

« Prev Topic | Next Topic »

Permissions