> How do I find out the direct and indirect foreign key relationships? > Say, for example there are four tables A, B, C and D of which A is the > parent table and B, C and D are child tables. Say B and C are related to A > directly and D is related to A through C. How do I find out this indirect > relationship apart from the direct relationships? Any help in this regard > is very much appreciated.
The DataBee software has a Chain Finder tool in the Set Designer which displays exactly this. DataBee is designed to create referentially correct subsets of Oracle databases and isn't free. However we do offer a 30 day evaluation which might enable you to get done what you want to do. If you would like to have a go at it drop me a note and I'll arrange to get an eval key over to you. Here's a link to the Chain Finder help page - it has a nice picture of the relationship display. http://www.databee.com/sdchainfinder.htm Regards Dale --------- Quickly and easily create test and development databases with DataBee. http://www.DataBee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).