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

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):

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