Databases Reference
In-Depth Information
136
CustomerName
field 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.) The SQL command for deleting the Warehouse field from the Part table is as follows:
ALTER TABLE Part
DELETE Warehouse
;
In Access, you can delete a field in Table Design view by selecting the field and pressing the Delete key.
Access then will ask you to confirm the deletion of the field, as shown in Figure 4-24. Clicking the Yes but-
ton permanently deletes the field and the data it stores.
Field to be
deleted
FIGURE 4-24
Dialog box that opens when a field in Access is deleted
