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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL » Result sets in Interactive SQL

 

Deleting rows from the database using Interactive SQL
 Delete a row from the result set

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

  1. 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.

    If you want 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.