Saving a Database Diagram

Save your database diagram to update the database with the changes you made to the diagram layout and object definitions in the diagram. Database diagrams are saved in the dtproperties table of the database.

If you want to discard the changes to the diagram layout, but keep the option to save the changes to the object definitions at a later time, you can save a change script. You can then run the change script at some other time to update the database. You can also edit the change script’s Transact-SQL code in a text editor before you run it.

To save a database diagram

See Also