Save Change Script Dialog Box (Visual Database Tools)
Applies To: SQL Server 2016 Preview
This dialog box shows the Transact-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.
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.
Change scripts provided by Visual Database Tools contain no error handling. They assume that database objects have not changed since the tool was opened, and that change-related problems will therefore not occur. Before running a change script, you should include the appropriate error-handling statements.
- 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.
Bring up the Save dialog box where you can choose the location for the text file.
Cancel the creation of the change script.