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 for all feature classes or tables you plan to edit through a feature service.
You cannot run this tool on tables or feature classes that are registered with the geodatabase.
You must be the owner of the table or feature class 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, this tool will not add another one.
The following field types are added:
| DBMS | Data type |
|---|---|
Dameng | int32 with identity property |
Db2 | integer as identity |
Oracle | number (with database sequence and trigger if created in Oracle 11g; with identity if created in Oracle 12c or later releases) |
PostgreSQL | serial |
SQL Server | integer with identity property |
| Label | Explanation | Data Type |
Input Table
| The location and name of the table or feature class to which an ID field will be added. | Table View |
Field Name
(Optional) | The name to be used for the ID field. If no input is provided, the default ObjectID will be used. | String |
| Label | Explanation | Data Type |
| Updated Input Table | The input table that is updated to include an incrementing ID field. | Table |
arcpy.management.AddIncrementingIDField(in_table, {field_name})| Name | Explanation | Data Type |
in_table | The location and name of the table or feature class to which an ID field will be added. | Table View |
field_name (Optional) | The name to be used for the ID field. If no input is provided, the default ObjectID will be used. | String |
| Name | Explanation | Data Type |
| out_table | The input table that is updated to include an incrementing ID field. | Table |
Adds an ID field—FSID—to a table named violations owned by user insp when run from the Python window.
import arcpy
arcpy.AddIncrementingIDField_management("C:/Data/DatabaseConnections/mydb.sde/insp.violations", "FSID")