have legacy project with 600 tables and 1500 queries. would like to automatically generate an overview of relations (basically the generator would have to analyse the FROM clause of a query to see which tables or other queries are referenced).
can TOAD such things at all?
in the Help (“Diagram Relationships”) I see such notions as “to view dependencies (DESCRIBE)” and “number of levels of referential tables to include”. what is meant there? could that be what I intuitively am looking for?
thanks,
Pete