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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL » Result sets in Interactive SQL


Deleting a row from an Interactive SQL result set

You can delete a row from a result set in Interactive SQL.


You must have DELETE privilege on the table to delete rows.

You must have executed a query to have a result set.

  1. In Interactive SQL, select the row(s) you want to delete. To select a row(s):

    • Press and hold the Shift key while clicking the row(s).

    • Press and hold the Shift key while using the Up or Down Arrow.

    To delete non-consecutive rows, you must delete each row individually.

  2. Press Delete.

    The selected row(s) are removed from the database table.

  3. Execute a COMMIT to make the change permanent.


The row is deleted from the result set.