Generating SQL Statements from Result Sets

You can create INSERT, DELETE, and UPDATE statements for selected rows in the result set.

  1. Select the row(s) you want to generate a statement for.
  2. Right-click the selection, choose Generate, and then choose INSERT Statement, DELETE Statement, or UPDATE Statement. The statement is copied to the clipboard.