ArcGIS Developer Help  (GeoDatabase)    

IFields Interface

Provides access to members that return information about the fields.

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.


The Fields object represents a collection of columns in a table. The term field is synonymous with column. Each table in a database has an ordered collection of fields, there is always at least one field in a table. The ordered collection behaves like a list, so it is possible to access individual fields by a numbered position (or index) in the list.


Read-only property Field The field at the specified index in the fields collection.
Read-only property FieldCount The number of fields in the fields collection.
Method FindField Finds the index of the named field in the fields collection.
Method FindFieldByAliasName Finds the index of the field with the alias name in the fields collection.

CoClasses that implement IFields

CoClasses and Classes Description
Fields ESRI Fields Object.


The IFields interface provides information about a Fields collection and also provides access to individual fields. This example finds any fields in a feature class which have a distinct alias name.

Set pFields = pFeatureClass.Fields
For i = 0 To (pFields.FieldCount - 1)
  Set pField = pFields.Field(i)
  If (pField.Name <> pField.AliasName) Then
    Debug.Print pField.Name & “:” & pField.AliasName
  End If
Next i

When using IFields::FindField, remember that there are equivalent methods on IClass and ICursor—they are shortcuts which save you having to get the Fields collection.

When programming with ArcMap, there is a distinction between IFields and two other interfaces, ILayerFields and ITableFields. ILayerFields is particular to an ArcMap layer, so for example, an alias name belongs to the field as defined in that layer rather than being stored with the underlying table.


Feedback Send feedback on this page