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, and/or rasters with attribute tables. | |
Adds a database-maintained ID field to an existing table or feature class in a Dameng, IBM Db2, Microsoft Azure SQL Database, Microsoft SQL Server, Oracle, or PostgreSQL database. A database-maintained ID field is required on all feature classes or tables you plan to edit through a feature service. | |
Alter Field Properties | This tool provides the ability to rename fields or field aliases for any geodatabase table or feature class. |
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. | |
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. | |
Switch data stored in fields or columns to rows in a new table or feature class. |
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. |