The Delete command removes the selected rows from a database table. You must have delete permission on the table to delete rows.
Deleting a row from the result set
Select the row(s) you want to delete. To select a rows:
Press and hold the Shift key while clicking the rows.
Press and hold the Shift key while using the Up or Down arrow.
To delete non-consecutive rows, you must delete each row individually.
Right-click the result set and choose Delete from the pop-up menu. You can also delete the selected row(s) by pressing the Delete key.
The selected row(s) are removed from the database table.
Execute a commit statement to make your changes to the table permanent.
