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.

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.
Right-click the result set and choose Delete. You can also delete the selected rows by pressing the Delete key.
Execute a commit statement to make your changes to the table permanent.