Export (0) Print
Expand All
Expand Minimize

Save Change Script Dialog Box

This dialog box shows the SQL script for the changes you have made since you last saved the table. It also allows you to save the script to a text file at a location you choose.


If you save the script to a text file and later execute it, you should review the script in detail, as there is no error-handling facility for undoing any data loss that occurs.

You can access this dialog box after you have made unsaved changes to a table in Table Designer. On the Table Designer menu, click Generate Change Script.


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.

Automatically generate change script on every save

If checked, the Save Change Script dialog box will appear any time you save changes to a table.

Yes Button

Brings up the Save dialog box where you can choose the location for the text file.

No Button

Cancels the creation of the change script.

Community Additions

© 2015 Microsoft