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.
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?
@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?
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.