Ability to view Database Sequence in ArcGIS Pro

4403
13
04-28-2021 09:38 AM
Status: Open
Labels (1)
Brian_McLeer
Occasional Contributor II

In creating database sequences, there is not a streamlined way to view database sequences that have been created. I have seen other posts of using Python to list database sequences, but that seems to only be applicable to file geodatabase and not enterprise databases. 

List Database Sequences for Enterprise Geodatabase 

Being able to view database sequences in a database would be beneficial, especially as these can interact with attribute rules to auto-generate values. Viewing along the same lines as you can for attribute rules, domains, subtypes, etc. 

13 Comments
MatthewStull1

I need to delete all the sequences in my Enterprise (SDE) geodatabase.  Can I simply go into SQL Server Management Studio and do the deletes there or should I just use the DeleteDatabaseSequence in Pro?

Brian_McLeer

@MatthewStull1 I always prefer to use geoprocessing tools before SQL, usually cleaner that way. Maybe you can use the batch version of the GP tool? 

MatthewStull1

I just ended up making a model in Model Builder and then exported it to Python.  Then I simply added additional lines in the code to do a batch delete of all my sequences.  It worked perfectly.  

I will say that I support the idea that Brian originally posted.  Having a view, like how we can see domains in Pro, to see all the sequences and be able to edit, add or delete them there would be really helpful!