getting Child Tables List for a Given Table using SMO

• Rajendra Prasad

  Valued Member

  Points: 64

  More actions

  May 9, 2007 at 9:51 pm

  #371224

  Hello All,

  Can any one tell me  how to get the list of child tables for a given table. I am able to backtrack it. ie, given a table i am able to retrieve all its parent tables.. can anybody throw light on this..

  Thanks Much!!

  -Raj.

  ---

  Regards,

  Raaja

• Camilo Torres

  SSCrazy

  Points: 2034

  More actions

  May 10, 2007 at 7:59 am

  #705495

  Open a new query window switch to the DB in question and run: select * from sys.sysdepends

  The ID and DEPID columns use them to find the objects using query below (replace id with your ids)

  select * from sys.sysobjects where id in( 69575286,21575115)

  You can find the logic from here to build your tree.