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 » Editing result sets in Interactive SQL

 

Copying rows from an Interactive SQL result set

You can copy cells, rows, and columns directly from the result set in Interactive SQL and then paste them into other applications. Copying rows and columns copies both the column headings and table data into the clipboard. You can only copy one column at a time.

Copied data is formatted according to the following Interactive SQL options:

You can also change these options from the Interactive SQL Options menu, by choosing Import/Export.

If these options are set to their defaults, the copied data is comma-delimited and the strings are enclosed in single quotes.

To copy rows from the Interactive SQL result set
  1. Select the row(s) in the result set that you want to copy.

  2. Right-click the selection and choose Copy » Copy Selected Row(s).

    The selected row(s), including their column headings, are copied to the clipboard.

    You can now paste the row(s) into other applications.

To copy a column from the Interactive SQL result set
To copy individual values from the Interactive SQL result set