Delete a row from a table

To delete a row in a table, you must have authorization to the table.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Table container.
  5. Right-click the table and select Edit contents.
  6. Select the row you want to delete by clicking the leftmost cell in the row. The leftmost cell is the one that is gray. If you want to delete more than one row, hold the Ctrl key down while clicking the leftmost cell of each row you want to delete.
  7. From the Rows menu, select Delete, or press the Delete key.

Tip: To select consecutive rows, drag the cursor down the leftmost column.