Delete Field (Data Management)

ArcGIS Pro 3.4 | | Help archive

Summary

Deletes one or more fields from a table, feature class, feature layer, or raster dataset.

Usage

    Caution:

    This tool modifies the input data. See Tools that modify or update the input data for more information and strategies to avoid undesired data changes.

  • You can specify either the fields to delete or the fields to keep.

    • To delete fields, use the Fields parameter to specify the fields to delete, and set the Method parameter to the Delete Fields option.
    • To keep fields, use the Fields parameter to specify the fields to keep, and set the Method parameter to the Keep Fields option.

  • Fields cannot be deleted from nonnative, read-only data formats in ArcGIS, such as VPF and CAD datasets.

Parameters

LabelExplanationData Type
Input Table

The table containing the fields to be deleted. The existing input table will be modified.

Mosaic Layer; Raster Layer; Table View
Fields

The fields to be deleted or kept from the input table, as specified by the Method parameter. Only nonrequired fields can be deleted.

Field
Method
(Optional)

Specifies whether the fields specified by the Fields parameter will be deleted or kept.

  • Delete FieldsThe fields specified by the Fields parameter will be deleted. This is the default.
  • Keep FieldsThe fields specified by the Fields parameter will be kept; all other fields will be deleted.
  • Delete FieldsThe fields specified by the drop_field parameter will be deleted. This is the default.
  • Keep FieldsThe fields specified by the drop_field parameter will be kept; all other fields will be deleted.
String

Derived Output

LabelExplanationData Type
Update Input Table

The updated dataset.

Table View; Raster Layer; Mosaic Layer

Environments

Licensing information

  • Basic: Yes
  • Standard: Yes
  • Advanced: Yes

Related topics