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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL » Editing result sets in Interactive SQL

Deleting rows from the database using Interactive SQL Next Page

Copying rows from an Interactive SQL result set

You can copy rows directly from the result set in Interactive SQL and then paste them into other applications. Copying rows copies both the column heading and table data into the clipboard. Copied data is comma-delimited and all of the strings are enclosed in single quotes.

To copy rows from the Interactive SQL result set
  1. Select the row(s) you want to copy. To select a row(s):

  2. Press Ctrl+C to copy the selected row(s).

    The selected row(s), including their column headings, are copied to the clipboard. You can now paste them into other applications.

  3. Copying individual values from the result set

    You can copy a single value from the result set by selecting a value, right-clicking the result set and choosing Copy Cell from the popup menu. When you do this, no column headings are copied—only the data is copied, and no quoting is done.