Table Tree

• kd11

  Hall of Fame

  Points: 3447

  More actions

  January 5, 2011 at 12:12 pm

  #100339

  Does any know if there is a script (out there ) that will return a list of table which is related to a table you provide.

  i.e exec displaytbltree Table A

  output:

  01 Table A

  02 - TableB

  02 - TableC

  02 - TableD

  03 -TableE

  03 - TableF

  02 - TableG

  02 - TableH

• WayneS

  SSC Guru

  Points: 95460

  More actions

  January 5, 2011 at 3:35 pm

  #1269794

  There are plenty here on this site; just search for dependency in the scripts section.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2