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.
Note
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.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. 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.
See Also
Tasks
How to: Generate Change Scripts