Deleting Rows from the Database Using Interactive SQL

The Delete command removes the selected rows from a database table.

You must have delete permission on the table to delete rows.
  1. Choose a method to select the rows you want to delete:
    • Press and hold the Shift key while clicking the rows.

    • Press and hold the Shift key while using the Up or Down arrow.

    Delete nonconsecutive rows individually.

  2. Right-click the result set and choose Delete. You can also delete the selected rows by pressing the Delete key.
  3. Execute a commit statement to make your changes to the table permanent.