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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL » Executing SQL statements from Interactive SQL

Executing SQL statements from Interactive SQL Next Page

Executing multiple 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. See command_delimiter option [Interactive SQL].

An alternative to using the semicolon is to enter the separator go on a line by itself, at the beginning of the line.

By default, Interactive SQL shows the first result set of the last statement executed. If you want to see all the result sets from the last statement, you can select the Show Multiple Result Sets option on the Results tab of the Options dialog.

Tip

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