Deleting Rows from the Database Using Interactive SQL

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

1. Select the row(s) you want to delete using one of these methods:
   1. Press and hold the Shift key while clicking the row(s).
   2. Press and hold the Shift key while using the Up or Down Arrow.
2. Press Delete.
3. Execute a COMMIT to make the change permanent.