How to: Save Database Diagrams
By saving a database diagram, you can save all the changes you made to it, including any changes you made to the tables, columns and other database objects.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
To save the database diagram
From the File menu, choose Save <tablename>.
If this is a new diagram that you have never before saved, the Save As dialog box appears. Type a name for the diagram.
If you made changes to tables in an existing diagram, the Save dialog box appears and displays a list of changes that will be saved in the database when you save your diagram.
Click Yes (or OK if this is a new diagram) to update the database to match your diagram.