Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Question Unanswered: help:Sql logic needed to generate table hierarchy i sybase database

    Hello,
    Am trying to generate a hirrarchy of all tables in our sybase database. this hirerachy should be output in the format
    parent|child1|child2|child3|....|child n

    This hierarchy will will then be used to truncate tables in the correct order. Any thoughts on how to code the sql is greately appreciated

    thanks for your time
    -sunny

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    sp_depends does the job.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •