Working with commands in Interactive SQL

The following chapters describe some of the commands you can use in Interactive SQL. This section describes general tasks for working with commands in Interactive SQL.

All SQL statements can be entered as commands in the top pane of the Interactive SQL viewer. When you are finished typing, you need to execute the statement to run it.

StepsTo enter a command:

  1. In the SQL Statements pane, type the command.

StepsTo execute a command, do one of the following:

  1. Press the Execute SQL Statement button or choose SQL > Execute or press F5.

StepsTo clear the SQL Statements pane:

  1. Choose Edit > Clear SQL or press Escape.

NoteTips You can execute only a selection of text in the SQL Statements button by pressing F9.

Syntax error messages appear in the ISQL Error pop-up window. To see more information on an error, click Help. (Do not use the Online Books button in the Help window.)

Other messages about an executed statement, such as execution times, can appear in the Messages pane. You control the display and content of Message information in Tools > Options > Messages.