Change the SQL statement type

You can change the type of SQL statement that you are creating using SQL Assist. In some environments, you can only create SELECT statements. In other environments, you can also create INSERT, UPDATE, and DELETE statements.

To change the SQL statement type:

  1. In the Outline view, click the main SQL statement properties node.
  2. In the Details area, select the type of SQL statement that you want to create. A message window opens to confirm that you want to discard all changes and start a new statement.
  3. Click OK to close the message window. A new template appears in the Outline view.