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.

Note:
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.

 Options

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

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

No

Cancel the creation of the change script.