Saving and Reusing a Script

You can save the contents of an SQL Edit window to a .SQL file and retrieve it later to edit or run.

To save an SQL script from an active SQL Edit window:

1. From the File menu, click the Save As command.

   SQLWizard displays the Save As dialog box.

2. Choose SQL Scripts (*.SQL) from the list of Object Types.
3. Provide a name for the file.
4. Click OK to save the file.

To open an SQL script from an active SQL Edit window:

1. From the File menu, click the Open command.
2. Choose SQL Scripts (*.SQL) from the list of Object Types.
3. Locate and select the file you want to open; then click OK.

   The script is opened in an SQL Edit window.

4. Edit the file adding and deleting the necessary SQL commands. You can also incorporate batch commands.