InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 23:20:58 GMT20http://www.sqlservercentral.com/Forums/Topic801897-1665-1.aspxThat is correct. This simple tutorial script solves the problem I had and is a sample for you to refactor and write whatever you want.CirquedeSQLeil is going to write the recusive script that query FK hierarchy and publish here.Tue, 19 Jan 2010 07:38:09 GMTjswong05http://www.sqlservercentral.com/Forums/Topic801897-1665-1.aspxThis script is a nice starter script. What I see from the script is that it lists all of the foreign keys. After that, you are required to manually create the hierarchy of FKs and table relationships. Building that hierarchy is the time consuming piece.Fri, 18 Dec 2009 12:03:05 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic801897-1665-1.aspxThis URL even helps determine the columns involved in that Foreign Key.[url=http://sqlserver2000.databases.aspfaq.com/schema-how-do-i-find-all-the-foreign-keys-in-a-database.html]http://sqlserver2000.databases.aspfaq.com/schema-how-do-i-find-all-the-foreign-keys-in-a-database.html[/url]Wed, 28 Oct 2009 09:55:21 GMTasnandreyhttp://www.sqlservercentral.com/Forums/Topic801897-1665-1.aspxEXEC sp_helpconstraint 'TableName' for single tables is simpler and covers all constraints.Tue, 27 Oct 2009 12:57:51 GMTChip Broeckerhttp://www.sqlservercentral.com/Forums/Topic801897-1665-1.aspxsimpler statementselect object_name(referenced_object_id) as PrimaryKeyTable ,object_name(parent_object_id) as ForeignKeyTable ,*from sys.foreign_keyswhere object_name(referenced_object_id) like '%mySearchedPrimaryKeyTable%'order by object_name(referenced_object_id) ,object_name(parent_object_id) Tue, 27 Oct 2009 08:02:31 GMTNorbert L. Muth, M.A.http://www.sqlservercentral.com/Forums/Topic801897-1665-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Primary+key/68346/">Find Foreign Key Tables</A>[/B]Mon, 12 Oct 2009 19:10:18 GMTRepriser-991084