How can we help you today? How can we help you today?

quick ER diagram from script

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
austrianfoodispuke
0

Comments

2 comments

Sort by
  • David Atkinson
    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
    0
  • austrianfoodispuke
    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]
    austrianfoodispuke
    0

Add comment

Please sign in to leave a comment.