Menu
Given that many frameworks will create complicated (and maybe not so readable/logical) SQL queries, it would seem that having a tool to show, visually, how the joins were done might be a helpful tool. But I have not found such a tool.
I took a query that included a lot of tables and created a graphic as an example of what I think would be the output from such a tool:
The text on the links are the field names that are used in the join. The bold items are inputs to the query. The table names ending in digits are just repeat instances of the same table (ie Partner and Partner2 are the same table, just part of the query more than once).
I would like to be able to drop an SQL query into a tool and see a diagram like this. Possible?
409
If you need a more polished tool that's ready to go out of the box, a paid data-visualization tool for SQL is a good way to go. Each has a unique way of dealing with SQL and visualizing data, so what's good for other companies may not be the right choice for you.
Four types of joins: left, right, inner, and outer.
I found this tool, it might be useful.
http://queryviz.com/online/
Although the SQL syntax supported looks to be quite limited..
114
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
