An overview of the Fields toolset

The Fields toolset contains a set of tools to add and make changes to the fields in the tables of a feature class. A field is a column in a table; each field contains the values for a single attribute. Any number of fields can be included in a table. Settings can be specified for fields, such as the field type and the maximum size of the data that can be stored in it.

Tool	Description
Add Field	Adds a new field to a table or the table of a feature class, feature layer, raster catalog, and/or rasters with attribute tables.
Add Incrementing ID Field	The Add Incrementing ID Field tool adds a database-maintained ID field to an existing table or feature class in an IBM DB2, Microsoft SQL Server, Oracle, or PostgreSQL database. This type of field is required on all feature classes or tables you plan to edit through a feature service.
Assign Default To Field	This tool will create a default value for a specified field. Whenever a new row is added to the table or feature class, the specified field will be set to this default value.
Calculate End Time	Calculates the end time of features based on the time values stored in another field.
Calculate Field	Calculates the values of a field for a feature class, feature layer, or raster catalog.
Convert Time Field	Converts time values stored in a string or numeric field to a date field. The tool can also be used to convert time values stored in string, numeric, or date fields into custom formats.
Convert Time Zone	Converts time values recorded in a date field from one time zone to another time zone.
Delete Field	This tool deletes one or more fields from a table, feature class, feature layer, or raster dataset.
Disable Editor Tracking	Disables editor tracking on a feature class, table, mosaic dataset, or raster catalog.
Enable Editor Tracking	Enables editor tracking for a feature class, table, mosaic dataset, or raster catalog.
Transpose Fields	Shifts data entered in fields or columns into rows in a table or feature class.

Legacy:

The following tools were available prior to version 10.0, but have been removed as they are no longer applicable.

Tool	Recommendation
Calculate End Date	Use the Calculate End Time tool to populate the specified end date field with values calculated using the start date field.
Transpose Time Fields	Use the Transpose Fields tool to create timestamps from the time columns in a table or feature class.