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:
- In the Outline view, click the main SQL statement properties
node.
- 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.
- Click OK to close the message window. A new template
appears in the Outline view.
Return to Edit an SQL statement