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.