How to: Save Selected Tables on a Diagram
You can save a specific table or a set of tables if you do not want to save all the changes you made in a database diagram.
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 Visual Studio Settings.
To save selected tables
In your database diagram, select the tables you want to save.
From the File menu, choose Save Selection.
The Savedialog box displays the list of tables that will be updated in the database when you save your selection.
Choose Save Text File if you want to save the list of tables in a text file in the project directory before continuing.
In the Save dialog box, confirm the list of tables and choose Yes to save these tables.
Note
The list of tables may contain tables in addition to those selected. For example, if you change the data type of a column that participates in a relationship with another table, both tables will be included in this list.