Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Administering Your Database » SQL Anywhere graphical administration tools » Using Interactive SQL

 

Generating SQL statements from result sets

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

To generate SQL statements from an Interactive SQL result set
  1. Select the row(s) you want to generate a statement for.

  2. Right-click the selection, and choose Generate, and then choose INSERT Statement, DELETE Statement, or UPDATE Statement.

    The statement is copied to the clipboard.