Options

quick ER diagram from script

austrianfoodispukeaustrianfoodispuke Posts: 100
edited February 6, 2009 9:29AM in SQL Prompt Previous Versions
I'm currently working with an unfamiliar db and would at times be aided by the ability of viewing an ER diagram of the query.

SSMS does not seem to have such functionality, can this be added to prompt?

Would also be good if this could be combined with my 'data sample pop up' suggestion
· Share on Twitter

Comments

  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    This sounds interesting. Could you describe what you mean by "ER diagram of the query", maybe with a simple example using Northwind or Adventureworks?

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • Options
    austrianfoodispukeaustrianfoodispuke Posts: 100
    e.g.
    SELECT ...
    FROM tableA A
    INNER JOIN tableB B on A.ID = B.ID
    LEFT OUTER JOIN tableC C ON C.val = B.val

    would show a simple diagram showing 3 tables (no columns) with lines linking A to B, B to C

    perhaps also showing the aliases of the tables and the IDs with which they're linked

    [I guess you could always extend this so clicking on any table highlights output columns within the text]
    · Share on Twitter
Sign In or Register to comment.