Saving 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.

To save selected tables

1. In your database diagram, select the tables you want to save.
   
   
2. Right-click one of the selected tables, and choose Save Selection.
   
   
3. The Save dialog 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. When a message box displays the name of the saved text file, choose OK.
   
   
4. 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.

See Also

Saving a Change Script