title: Is there a stored procedure that creates the sysdiagrams table and supporting stored procedure?
body: <p>Currently, our local builds include a database build &amp; deploy step that deploys databases to the developers' local machines based on a database model contained within a Sql Server 2008 Database Project. This is fine for deploying the database schema, but is unable to deploy any database diagrams that have been defined.</p>
  
  <p>In order to deploy the diagrams, we are currently having to include CREATE scripts for the sysdiagrams table and the stored procedures upon which the designer is dependent, and a data insert script for the diagram definitions, as part of the post deployment stage. </p>
  
  <p>Is there a better way to deploy the sysdiagrams table and stored procedures? These are created within sql server management studio when clicking yes in the dialog that asks whether I'd like to create the support objects for diagramming - does this invoke something that I can hook into? I can't find a relevant stored procedure.</p>