English

How To: Remove multiple fields from a table or dataset through ArcMap

Summary

It is not possible to select and delete multiple fields from an attribute table through ArcMap. Instructions provided describe how to remove multiple fields from a table or dataset simultaneously by exporting the feature class or by using the Delete Fields geoprocessing tool.

Procedure

One way to remove multiple fields from an attribute table is to use the Delete Fields tool in the Data Management Tools > Fields toolbox.

If the use of a geoprocessing tool is undesirable, then the following steps will walk you through removing the fields through ArcMap. This task can be used with a shapefile, stand-alone dBase table, SDE feature class, SDE table, or personal geodatabase feature class or table.

  1. Add the data layer to ArcMap.
  2. Double-click the layer name in the ArcMap table of contents to access the Layer Properties dialog box.
  3. Click the Fields tab.
  4. Click Clear All to turn visibility off for all fields.

    Note:
    The Clear All button located at the bottom of the Fields tab allows for controlling visibility of all fields in the layer simultaneously.

  5. Check each field you wish to retain.
  6. Click OK.
  7. Right-click the layer and select Data > Export Data.
  8. From the Export Data dialog box, change the file name, desired output file format, and output file location, if necessary, and click OK.
  9. Add the newly created dataset to ArcMap and verify that all fields with the visibility setting turned off were carried over into the new layer.