Tool to convert T-SQL to graphical model?

Question

Sometimes I am looking at complex SQL Server SQL statements and wondered if there's a tool which can represent the query into a graphical model.

For example:

You have a select query which joins (could be inner + left and right joins) with 10 tables. Is there a tool to take this query, represent the 10 tables graphically and draw the different joins as relationships? And better yet, if you modify the joins and conditions graphically, it automatically updates the generated sql.

Think of it like a reverse query builder. You start from the sql query and end at the model.

Answer 1

It's not a perfect solution but you can always view the query execution plan.

Answer 2

The Query Designer in Management Console is actually two-way. You can use it to draw your query graphically, or you can paste or type in your t-sql and it will show a graphic display.

Just open a query window, then hit Ctrl-Shift-Q or choose "Design Query in Editor" from the Query menu.

Answer 3

Though not exactly what you are asking for, the TSQL Script Explorer from ISpySQL.com will come close. Disclaimer, I'm part of ISpySQL.com. Rob Vallee