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 |
---|---|
Adds a new field to a table or the table of a feature class, feature layer, raster catalog, and/or rasters with attribute tables. |
|
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. | |
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. |
|
Calculates the end time of features based on the time values stored in another field. |
|
Calculates the values of a field for a feature class, feature layer, or raster catalog. |
|
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. | |
Converts time values recorded in a date field from one time zone to another time zone. | |
This tool deletes one or more fields from a table, feature class, feature layer, or raster dataset. |
|
Disables editor tracking on a feature class, table, mosaic dataset, or raster catalog. | |
Enables editor tracking for a feature class, table, mosaic dataset, or raster catalog. | |
Shifts data entered in fields or columns into rows in a table or feature class. |
![Legacy Legacy](rsrc/legacy.png)
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. |