ASA Getting Started
  Using Interactive SQL
    Using Interactive SQL to display data
      Editing table values 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. You can select only consecutive rows in the result set.

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. Right-click the result set and choose Delete from the popup menu. You can also delete the selected row(s) by pressing the Delete key.

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

3. Execute a COMMIT statement to make your changes to the table permanent.