Visual aids for SQL

general discussion
1

I frequently find myself looking at freehand sql, sometimes with the intention of making changes to a universe to enable it to generate the sql, but more generally to look at improving a query’s performance.

I always end up drawing an entity relationship diagram of the query as this helps me visualise the relationships clearly. I began to wonder if there is a small utility out there, or a function within a bigger program which does that. Has anybody come across such a facility?

I currently use Toad 7.6.0.11 and there is a thing in there called code road map, which does for pl/sql at least part of what I want to do with regular sql.

So what I want is a piece of software which you supply with an sql statement and out comes an entity relationship diagram.

TIA

Paul

Paul Shovlar :uk: (BOB member since 2002-09-05)

2

I am not 100% sure, but I think Compuware Numega’s DevPartner has a module to do that. It was more than a year ago when I was evaluating the DevPartner.

Hope this helps.

simon.

substring :us: (BOB member since 2004-01-16)