SQL Anywhere® Server - Database Administration  > SQL Anywhere Administration Tools  > Interactive SQL  > Executing SQL statements from Interactive SQL

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.