Batch SQL Scripts Overview

A batch script is a set of SQL statements that have been stored in a text file. A script is usually created by saving the contents of the SQL Edit window to an .SQL file. Once the script has been saved, it can be replayed at any time using the SQLWizard's Run Batch command. It can also be executed directly from your system's command line.

Any operation that can be performed interactively can be performed from a script-- you can create tables, insert and delete records, view query results, and more. A batch script is particularly useful to automate tasks that are run on a regular basis. Once you have created a script, it can be used over and over.