Executing SQL Statements One at a Time

To execute SQL statements individually, use the Single Step option. This is useful when debugging.

  1. Type your query in the SQL Statements pane.
  2. Place your cursor in the statement that you want to execute.
  3. Select SQL > Single Step or press Shift+F9.
    The selected SQL statement executes and the next SQL statement is selected.
  4. Press Shift+F9.
    The selected SQL statement executes.
  5. Repeat the previous step until there are no more selected statements to execute.
Related tasks
Executing All SQL Statements
Executing Selected SQL Statements
Configuring the Execute Statements Toolbar Button