Changing the SQL Statement

The default statement is SELECT * FROM.

Procedure

  1. Right-click anywhere in the Outline pane and select Change Statement Type. The Change SQL Statement Type dialog is displayed.
  2. Select the statement you want - either SELECT, INSERT, UPDATE or DELETE.
  3. Click OK.

Result

The current contents of all three panes are cleared and the appropriate SQL syntax for the new statement is displayed in the Outline pane.