Add Incrementing ID Field (Data Management)
Summary
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.
Usage
-
This tool can only be used with database tables, not geodatabase tables.
You must be the owner of the table to add an ID field to it.
If you do not specify a name for the field, ObjectID is used by default. If a field named ObjectID already exists, the tool will not run until you provide a different name.
If a database-maintained, incrementing ID field already exists in the table, this tool will not add another one.
The following field types are added to the table:
DBMS
Data Type
DB2
integer as identity
Oracle
number (with database sequence and trigger)
PostgreSQL
serial
SQL Server
integer with identity property
Syntax
| Parameter | Explanation | Data Type |
in_table |
The location and name of the table to which you want to add an ID field. | Table View |
field_name (Optional) | The name to be used for the ID field. If no input is provided, the name defaults to objectid. | String |
Code Sample
Adds an ID field—FSID—to a table named violations owned by user insp when run from an ArcGIS for Desktop client computer on which a pre-created database connection file (.sde) is stored in the default connection file location.
AddIncrementField_management("Database Connections//insp.violations", "FSID")