Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Administering your database » SQL Anywhere graphical administration tools » Using Interactive SQL

 

Executing multiple SQL statements

You can execute multiple SQL statements from Interactive SQL as long as each statement ends with a command delimiter. The command delimiter is set with the command_delimiter option, and is a semicolon (;) by default. An alternative to using the semicolon is to enter the separator go on a line by itself, at the beginning of the line. See command_delimiter option [Interactive SQL].

Tip

You can press F9 to execute only the selected text in the SQL Statements pane.

You can press Shift+F9 to execute only the selected statement in the SQL Statements pane and select the next statement for execution.

 Showing multiple result sets
 See also