Save Change Script Dialog Box

See Also   Tasks

Displays a change script whenever there are unsaved database changes in your table or database diagram and enables you to save the change script as a text file with an .sql extension in the project directory. This dialog box appears when you choose Save Change Script from the File menu or click the Save Change Script button on the Database Designer toolbar. If you have selected to have a change script created automatically each time you save, this dialog box will not appear whenever you save your database diagram.

Options

Yes

Saves the SQL change script in the project directory. A message box will appear indicating where the change script file has been saved.

No

Cancels the save action.

Automatically generate change script on every save

Select this option to create a change script each time you save the database diagram or selected tables. This provides a record of all changes made to the database.

For more information about saving SQL change scripts, see Saving a Change Script.