Change the options for running an SQL script

To change the options for running an SQL Script:

  1. Open Run SQL Scripts.
  2. From the Options menu, select one of the following options:

Stop on Error
Turns stopping on errors on or off. If this option is selected and an error occurs, the SQL script stops running and the statement that resulted in an error remains selected.

Ignore 'Object Not Found' on DROP
When Stop on Error is selected, select this to ignore any SQL State 42704 errors (Object Not Found). Use this when your script is dropping objects that may or may not exist.

Check SQL Portability
Checks your SQL statements for any non-standard statements that might restrict you from porting your SQL statements.

Smart Statement Selection
Turns Smart Statement Selection on or off. When this option is selected, all highlighted statements are run in sequence when the Selected command on the Run menu is selected. If this option is not selected, the Selected command runs the highlighted text as a single SQL statement. Selecting Smart Statement Selection also ensures that complete statements are run even if one or more statements are only partially highlighted.

Display Results in Separate Window
Causes results from select statements to be displayed in a separate window instead of the Output pane.

Include Debug Messages in Job Log
Turns debugging for statements run in the Run SQL Scripts window on or off. You can see query optimizer and other database debugging messages by turning on this option, running your statements, and refreshing the Job Log window.

Run Statement on Double-click
When selected, this option allows you to run statements whenever you double-click the mouse.

Defer Run History
When selected, this options defers the output of run history in the Messages tab, for better performance.