Knowledge Base - Technical Articles


Technical Article   HowTo:  Remove multiple fields from a table or dataset through ArcMap

Article ID: 27336
Software:  ArcGIS - ArcEditor 9.0, 9.1, 9.2, 9.3, 9.3.1, 10 ArcGIS - ArcInfo 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcView 9.0, 9.1, 9.2, 9.3, 9.3.1
Platforms: N/A

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.

     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.

Created: 7/28/2004
Last Modified: 5/3/2011

Article Rating: (4)
If you would like to post a comment, please login

Comments

By Anonymous - 11/02/2009 7:51 AM

Other - See details below.

Has this feature been updated. I would like to delete multiple fields in a shapefile but not go through the pain of exporting and creating multiple copies as this article suggests.

Rating:

By Anonymous - 11/20/2008 3:44 PM

The article has missing, misleading, or conflicting information.

This article is patronising and factually incorrect - there is no way to delete multiple fields unless using an externally added script. The text would more accurately describe article topic thus - 'The deletion of multiple fields in ArcView is not possible. It is possilbe though, to create a new shapefile with a subset of existing fields achieving the same effect as deletion of multiple fields whilst having the advantge of retainng the source data.'.....

Rating:

By Anonymous - 02/05/2008 10:42 AM

Great article! It helped a lot!

Thanks for the article concerning how to delete multiple fields.

Rating:

By Anonymous - 01/25/2006 11:08 AM

I would like to see some VB code that does this very thing programmatically. Thank You Vince Smith

Rating: