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:
You can also delete an entire row without removing all of the column values one at a time.
- Open the INVENTORY_LIST table by double-clicking it.
- Delete the ORDER_QUANTITY value for the Envelopes, standard row. Because this column allows null values, you can delete the value.
- Delete the UNIT_COST value for the Lined tablets row. Because this column does not allow null values, the deletion is not allowed.
You should have a table that contains the following data.
- Open table INVENTORY_LIST by double-clicking it.
- Click the cell to the left of the UNKNOWN row. This highlights the entire row.
- Select Delete from the Rows menu or press the Delete key on your keyboard. The UNKNOWN row is deleted.
- Delete all of the rows that do not have a value in the QUANTITY_ON_HAND column from the INVENTORY_LIST table.
- Save the changes and view the contents by using View Contents.
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