idea Ability to view Database Sequence in ArcGIS Pro in Data Management Ideas

List Database Sequences

JoeBorgione — Tue, 12 May 2020 14:21:10 GMT

In Modify existing Geodatabase Sequences I have suggest that we be able to modify existing database sequences and additional functionality is needed as well: currently the only way to to list the sequences in a file geodatabase (and I assume an enterprise as well) is to use arcpy.da.ListDatabaseSequences().

You can right click on a fgdb and edit domains, and in doing so you get a list of all the domains in the gdb.

It would be cool to be able to do the same sort of thing with sequences: List them all and/or edit with one right click of the mouse.

List Database Sequences

JoeBorgione — Tue, 07 Sep 2021 17:55:13 GMT

You can right click on a fgdb and edit domains, and in doing so you get a list of all the domains in the gdb.

It would be cool to be able to do the same sort of thing with sequences: List them all and/or edit with one right click of the mouse.

Ability to view Database Sequence in ArcGIS Pro

Brian_McLeer — Wed, 14 Sep 2022 20:46:07 GMT

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.

Re: Ability to view Database Sequence in ArcGIS Pro

Brian_McLeer — Tue, 07 Sep 2021 17:50:44 GMT

Update on this, it has been logged as an enhancement request by working with an ESRI analyst a few weeks ago. The number is #ENH-000141842.

Re: Ability to view Database Sequence in ArcGIS Pro

RhettZufelt — Wed, 07 Sep 2022 23:47:07 GMT

Has this been implemented yet?

Re: Ability to view Database Sequence in ArcGIS Pro

Brian_McLeer — Wed, 07 Sep 2022 23:57:19 GMT

@RhettZufelt I just looked at MyEsri and there are no new notes in the activity log from when I submitted this last summer for the enhancement request.

Re: Ability to view Database Sequence in ArcGIS Pro

RhettZufelt — Thu, 08 Sep 2022 00:04:09 GMT

Thanks for the response. Though, I don't agree this should be an enhancement, but more of a bug/huge oversight.

Pretty much makes using the create sequence option useless for us when you don't even know if they exist, the name to use, etc......

Re: Ability to view Database Sequence in ArcGIS Pro

RhettZufelt — Thu, 18 Apr 2024 20:46:24 GMT

Since this still isn't implemented, figured I'd share a couple methods ESRI tech support supplied. Works for SQL Server at least:

SSMS > database > Programmability > Sequences

select name, start_value, increment, current_value from database_name.sys.sequences

Using the first route, you can reset them as well vs Arc where you need to delete them and re-create.

Re: Ability to view Database Sequence in ArcGIS Pro

CAkoth — Mon, 30 Jan 2023 13:46:11 GMT

Has this been implemented for File geodatabases?

Re: Ability to view Database Sequence in ArcGIS Pro

KoryKramer — Mon, 30 Jan 2023 15:15:04 GMT

@CAkoth yes, for file geodatabases. See https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/listdatabasesequences.htm

Re: Ability to view Database Sequence in ArcGIS Pro

RichardLittlefield — Fri, 03 Feb 2023 13:24:57 GMT

I agree. We need to be able to view the database sequence the same way we can see domains or tables/feature classes inside a file geodatabase. Not being able to see this makes it extremely difficult to know if they are being used or not, or even remembering what you named the sequence. Being able to see it is a much needed improvement. Please implement this in a future release.

Also being able to edit it would be helpful as well. If you are using it in an attribute rule to automatically number your features. What if you need to delete some features and would like to then manually update your sequence to start at where the edited features left off?

Looks like you can now view the sequence with python, however I'm not a python person by any means and I'm having issues trying to get the python syntax to successfully run. Not everyone knows python, so being able to see these sequences in some sort of viewing either through a table or similar to the domain view would be extremely helpful.

Re: Ability to view Database Sequence in ArcGIS Pro

MatthewStull1 — Thu, 18 Apr 2024 19:29:37 GMT

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?

Re: Ability to view Database Sequence in ArcGIS Pro

Brian_McLeer — Thu, 18 Apr 2024 19:51:44 GMT

@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?

Re: Ability to view Database Sequence in ArcGIS Pro

MatthewStull1 — Fri, 19 Apr 2024 15:35:50 GMT

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!

Re: Ability to view Database Sequence in ArcGIS Pro

AKRRMapGuy — Mon, 03 Mar 2025 18:06:41 GMT

Has anybody found a solution for Enterprise Geodatabses? The python tool only supports FGDBs... ESRI dropped the ball hard on this. Half a decade later and still no meaningful response from ESRI?

Re: Ability to view Database Sequence in ArcGIS Pro

Brian_McLeer — Mon, 03 Mar 2025 18:16:30 GMT

@AKRRMapGuy there is still not a front end way to view through ArcGIS Pro, but in Microsoft SQL Server you can run the query below to get a list of database sequences created on your DB.

SELECT * FROM sys.sequences;

Re: Ability to view Database Sequence in ArcGIS Pro

AKRRMapGuy — Mon, 03 Mar 2025 18:20:14 GMT

@Brian_McLeer Thank you, you are a saint and a scholar. I just ran into a situation where an Attribute Rule was failing saying the sequence didn't exist in the database, but then when I try to make a sequence with that name in Pro it fails because that sequence already exists.... 😵 A tool in pro to diagnose this sure would've been useful.

Re: Ability to view Database Sequence in ArcGIS Pro

TomAP — Wed, 09 Apr 2025 21:20:27 GMT

Have successfully used this Python script in Notebook in ArcGIS Pro to list Enterprise SQL database sequences and owners.

import arcpy

# Path to your SDE connection file
sde_conn = r"Q:\FolderPath\SDE.sde"

# SQL query to get sequence names and their schema owners
sql = """
SELECT
s.name AS SequenceOwner,
seq.name AS SequenceName
FROM
sys.sequences AS seq
JOIN
sys.schemas AS s ON seq.schema_id = s.schema_id
ORDER BY
s.name, seq.name;
"""

# Execute the query
executor = arcpy.ArcSDESQLExecute(sde_conn)
results = executor.execute(sql)

# Display results
if results:
print(f"{'Owner':<30}Sequence")
print("-" * 50)
for row in results:
print(f"{row[0]:<30}{row[1]}")
else:
print("No sequences found.")

Re: Ability to view Database Sequence in ArcGIS Pro

bfindlay — Fri, 14 Nov 2025 00:26:34 GMT

I can view sequences in a SQL Server database as mentioned above but we need this ability for file geodatabases so might as well make it part of the application I would argue.

If we could view the database sequences, similar to the way we can view a list of domains in a database, then choose one to view the current sequence value and increment value that would be a logical way to do things in my opinion.

Re: Ability to view Database Sequence in ArcGIS Pro

Brian_McLeer — Fri, 19 Dec 2025 23:01:16 GMT

This blog post was posted recently

https://community.esri.com/t5/data-management-blog/view-properties-of-database-sequences/ba-p/1657180/jump-to/first-unread-message