SQL script files

SQL script files are text files that contain SQL statements, and are useful to execute the same SQL statements repeatedly. Script files can be built manually, or they can be built automatically by database utilities. The Unload utility (dbunload), for example, creates a script file consisting of the SQL statements necessary to recreate a database.

Creating SQL script files

You can use any text editor that you like to create SQL script files but Interactive SQL is recommended for creating SQL script files. You can include comment lines along with the SQL statements to be executed.

Note

In Interactive SQL, you can load a SQL script file into the SQL Statements pane from your favorites.

SQL script files

Creating SQL script files

Note

See also