Re: Scripting database diagrams

From: Clay Beatty (clay_at_beattyhome.com)
Date: 04/14/04 

Date: 14 Apr 2004 13:30:41 -0700

>
>
> I normally create a database diagram that shows all the relations and use
> this while
> designing the database, but every time I make a change to the script and
> reexecute
> it, the diagram is dropped. I have searched everywhere for stored procedures
> or
> tables that can be used to specify the diagram, but I can't find it.
>
> Is it possible to generate a database diagram from sql?
>
Well, it is possible to script out your existing diagrams... I rolled
my own procedure to do it, and will forward it if you like. Just drop
me a note.

Also, see:
http://groups.google.com/groups?q=Scripting+SQL+Diagrams&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=b6b5b96c.0404051219.7866b440%40posting.google.com&rnum=1

-Clay

Relevant Pages

  • Re: Need a database diagram
    ... diagram that include foreign key. ... I have looked at sql server and Database Diagram and I haven't yet ... The Database Diagrams dialog in SQL Server should allow you to access ...
    (microsoft.public.sqlserver.programming)
  • LINQ SQL DataBase Diagram to DataClasses.dbml sync
    ... My project writes records to a new SQL Server 2005 database with ... When I change the Database Diagram for my ... Diagram and drag a replacement from the Server Explorer Table list. ... developing with an obsolete DBML Diagram. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to show foeign key in database diagram
    ... I use SQL server 2008 but I have found the same problem in SQL server ... I have the Northwind database and if I create a database diagram for this ... it doesn't show any information about which column is the foreign key in ...
    (microsoft.public.sqlserver.programming)
  • Re: Diagram to Image
    ... If you are using SQL Server 2005, and generated the diagram in Management Studio: ... I have created a Database Diagram for the tables I have in the database and set the relationships of the tables with the fields. ... Now I want to export this diagram to the Image format, so i can add this image in my documentation of the project documentation. ...
    (microsoft.public.sqlserver.tools)
  • Re: Visual Scripting component (maybe flowcharting)
    ... > TMS Software has also Diagram Studio, which is a tool to build diagrams ... > Studio and Diagram Studio, in order to provide a powerful tool for visual ... What I would like to see is the ability for an end user to design a script ...
    (borland.public.delphi.thirdpartytools.general)