Re: Does anyone have a script to display hierarchy of tables starting with a specific one

I have an AWK script that does a topological sort. It does what you ask for Informix (specific table, hierarchy of foreign keys).

The script just needs key-value pairs of tables dependent on each other. Get the pairs of tables from the oracle system catalog tables and run it through the script and Voila!

ref_load_ord -- a referential constraint graph script at

               http://www.tc.umn.edu/~hause011/

-- 


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

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011


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