What are the challenges you face when working across database platforms? Take the survey

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


  • Options
    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
  • Options
    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]
Sign In or Register to comment.