in a field calculate next number in sequence in sde

871
1
08-13-2019 06:11 AM
KennieHarris
New Contributor II

I have a field in our address point feature class in SDE (SQL) with a numerical (integer) unique ID. I need to either make it autopopulate new records with the next available ID or run a script that will calculate it nightly. Any ideas?

Tags (1)
0 Kudos
1 Reply
JoeBorgione
MVP Emeritus

This is a topic that's been discussed for a number of years:

Auto-Increment Field within SDE 

Generate an auto populating unique ID field in ArcMap  

....

But I just found this with Dr Google:  Add Incrementing ID Field—Data Management toolbox | ArcGIS Desktop 

That should just about do it....
0 Kudos