Deleting information from a table

 

You can delete information from a single column in a row or delete the row entirely. If a column requires a value, you cannot delete it without deleting the entire row. To delete some information in the INVENTORY_LIST table, follow these steps:

  1. Open the INVENTORY_LIST table by double-clicking it.

  2. Delete the ORDER_QUANTITY value for the Envelopes, standard row. Because this column allows null values, you can delete the value.

  3. Delete the UNIT_COST value for the Lined tablets row. Because this column does not allow null values, the deletion is not allowed.
You can also delete an entire row without removing all of the column values one at a time.

  1. Open table INVENTORY_LIST by double-clicking it.

  2. Click the cell to the left of the UNKNOWN row. This highlights the entire row.

  3. Select Delete from the Rows menu or press the Delete key on your keyboard. The UNKNOWN row is deleted.

  4. Delete all of the rows that do not have a value in the QUANTITY_ON_HAND column from the INVENTORY_LIST table.

  5. Save the changes and view the contents by using View Contents.
You should have a table that contains the following data.

ITEM_ NUMBER ITEM_ NAME UNIT_ COST QUANTITY_ ON_ HAND LAST_ ORDER_ DATE ORDER_ QUANTITY
153047 Pencils, red 10.00 25   20
229740 Lined tablets 1.50 120   20
303476 Paper clips 2.00 100 2003-09-22 50
559343 Envelopes, legal 3.00 500   20
775298 Chairs, secretary 225.00 6   20
073956 Pens, black 20.00 25   20

 

Parent topic:

Creating a table and defining a column