Resetting ObjectID after running Delete_Features on ArcSDE feature table?

Question

I have a python script that deletes all features on an ArcSDE feature table and then inserts new features to it.

I noted that the ObjectID keeps incrementing from where the last feature was with before deleted.

Just wondering if there is any reset function or tool to make ObjectID start with 1 every time the script runs?

• PolyGeo: Is your ArcSDE versioned? If so, I suspect your deletions are still being kept track of so the ObjectID would remain required. If not versioned, or if versioning can be removed as part of your script, then perhaps consider using Truncate Table to get a performance gain on your deletions. I suspect that this would reset your ObjectID counter.
• alextc: Thanks a lot. This solved the problem! How can I mark your answer correct?

Answer 1

If your ArcSDE is versioned, then I suspect your deletions are still being kept track of so the ObjectID would remain required.

If not versioned, or if versioning can be removed as part of your script, then perhaps consider using Truncate Table to get a performance gain on your deletions.

I suspect that this would reset your ObjectID counter.

Answer 2

this works great also without resetting your objID!

OBJ = arcpy.Describe(<layer>).OIDFieldName
with arcpy.da.SearchCursor(<layer>, OBJ) as Scursor:
 for row in Scursor:
 b = '''"{}"'''.format(OBJ) + " = {}".format(row[0])
arcpy.SelectLayerByAttribute_management(<layer>, "NEW_SELECTION", b)