Select Statement Diagram - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Select Statement Diagram

Author

Topic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-07-03 : 11:04:47

Does anyone know of a tool that would draw a diagram
of table/view joins in a select statement?

Or do i really have to code it myself?

Go with the flow & have fun! Else fight the flow

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-07-03 : 11:23:43

well SMSS has it.. kind of

you have to open a table paste a query in the sql pane and do "Show Diagram Pane"
and it shows the diagram.

Works in SQL Server 2000 too.

Go with the flow & have fun! Else fight the flow

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2006-07-03 : 12:47:17

What did you want it do to with subqueries?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-07-03 : 13:02:10

didn't get that far...

i got a select with 54 left joins and i wanted to see the structure in a diagram...

Go with the flow & have fun! Else fight the flow

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-07-03 : 14:00:35