Your browser does not support JavaScript. This help page requires JavaScript to render correctly. Tutorial: Deleting Rows from Tables with the Delete Selected Row(s) Tool
Skip Headers
Previous
Previous
 
Next
Next

Tutorial: Deleting Rows from Tables with the Delete Selected Row(s) Tool

This tutorial shows how to use the Delete Selected Row(s) tool to delete a row from the PERFORMANCE_PARTS table (populated in "Tutorial: Adding Rows to Tables with the Insert Row Tool").

To delete row from PERFORMANCE_PARTS using Delete Selected Row(s) tool:

  1. On the Connections tab, expand hr_conn.

    Under the hr_conn icon, a list of schema object types appears.

  2. Expand Tables.

    A list of tables appears.

  3. Select PERFORMANCE_PARTS.

  4. In the right frame, click the tab Data.

    The Data pane appears, showing the rows of the PERFORMANCE_PARTS table.

  5. Click the row where NAME is Results Orientation.

  6. Click the icon Delete Selected Row(s).

  7. Click the icon Commit Changes.

    The row is deleted.

    Under the Data pane is the Data Editor - Log pane.

  8. Check the Data Editor Log pane for the message "Commit Successful".

Note: If you delete every row of a table, the empty table still exists. To delete a table, see "Dropping Tables".

Related Topics

About the DELETE Statement

Creating and Managing Tables