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

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.