Database Reference
In-Depth Information
138
CustomerName
ield selected
Field Size property
changed
FIGURE 4-23
Changing a field property in Access
Some systems allow existing fields to be deleted. (Oracle is one system that does not allow existing fields
to be deleted.) For example, the following SQL command deletes the Warehouse field from the Part table:
ALTER TABLE Part
DROP COLUMN Warehouse
;
In Access, you can delete a field in Table Design view by selecting the field and pressing the Delete key.
Access will ask you to confirm the deletion of the field, as shown in Figure 4-24. Clicking the Yes button
permanently deletes the field and the data it stores.
Selected field
for deletion
FIGURE 4-24
Dialog box that opens when a field in Access is deleted
