Search code examples
sql-serversql-server-2000diagram

Is there a way to script diagrams in SQL 2000 (or save them another way)?


It's possible to create digrams in SQL Server 2000 that can be useful to show the relationships between tables. The problem we run into is that when somebody refreshes our development database, the diagrams get lost. We can load tables, stored procedures, views, etc. with SQL scripts, but we have to create the diagrams by hand.

Is there a way to script out the diagrams? Or can they be saved outside of the database some other way?


Solution

  • It can be done for SQL Server 2005 - see here.

    And info. on SQL Server 2000 - here.