Save Change Script Dialog Box (Visual Database Tools)
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.