Results 1 to 4 of 4

Thread: Table Hierarchy

  1. #1
    Join Date
    Dec 2004
    Posts
    54

    Unanswered: Table Hierarchy

    Can anybody tell me how to findout the hierachy relation (dependencies) ?

    My situation is, I have 500 tables and I need to delete some records in all tables so I would like to know from which table I have start because I blindly started with one table it is saying the parent table record can not be deleted.

    Please give some idea

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I think the information you need is in SYSCAT.REFERENCES

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit http://www.db2click.com/scribble.htm ... There is an SQL on this page which will list table dependencies

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126

    Re: table dependencies

    There need not be a strict table hierarchy, since tables may circularly reference each other.
    A table may even reference itself, e.g., an "employees" table with a column "direct supervisor".

    -- Peter Vanroose.

Posting Permissions

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