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

Inserting rows into the database from the Interactive SQL result set Next Page

Deleting rows from the database using Interactive SQL

You can also delete rows from a database table in Interactive SQL. You must have DELETE permission on the table to delete rows.

To delete a row from the result set
  1. Select the row(s) you want to delete. To select a row(s):

    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.