Post reply

Finding Parent-child Table tree in sql server 2000

  • August 28, 2008 at 5:11 am

    #123162

    Building Parent-Child Table Tree information using sql server 2000

  • August 28, 2008 at 5:26 am

    #864259

    Assuming you are talking about properly defined referential integrity you just have to create a diagram on Enterprise Manager.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • August 28, 2008 at 5:43 am

    #864264

    hello paul

    i need to find all the tables related to single table as a tree structure until the last level

    eg:

    Level-1 Level-2

    TABLEA ->TABLEB -> TABLEE ->TABLEH->TABLEI->TABLEK

    ->TABLEC -> TABLEF

    ->TABLED -> TABLEG->TABLEJ

    Expectred result

    Parent child

    ------- -----

    TABLEA TABLEB

    TABLEA TABLEC

    TABLEA TABLED

    TABLEB TABLEE

    TABLEC TABLEF

    TABLED TABLEG

    TABLEE TABLEH

    TABLEG TABLEJ

    TABLEH TABLEI

    TABLEI TABLEK

    Thanks in advance

    Sridhar

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply