Monday, 15 March 2010

visualization - Are there any tools to visualize a complicated SQL join? -


Given that many frameworks will not create complicated (and perhaps readable / logical) SQL queries, it appears To show a tool, visually, how involved could be a useful tool. But I have not found any such equipment.

I raised a question in which several tables were included and output from such a tool would have made me a graphic as an example:  Manually generated visualization

Links are text field names that are included in the use. Bold item queries are in the query. The table names that end in digits repeat the examples of the same table (i.e. partners and partners are 2 equal tables, more than one part of the query more than one).

I see a SQL query in one tool and thus a diagram. possible?

I found this tool, it could be useful

Although the supported SQL syntax looks quite limited ..

No comments:

Post a Comment