SQL geodatabase dbo.i tables?

[Anonymous User]

Hi all,

I'm looking in SQL Server Management Studio. I have a sql geodatabase that is esri version 10.9.1.2.9. I have researched and researched but I can't find the answer - does anyone know what these dbo.i__ tables are and what they are used for? Some kind of ID management.

AndreaB_0-1654808952484.png

AndreaB_1-1654809283805.png

Thank you,

Andrea

[VinceAngelo]

SEQUENCEs are too slow for bulk-loading data rows. Esri uses "i-tables" to implement the equivalent in batches, with the name using the table_registry identifier as a suffix.  They used to be documented, but I can't find where it moved in the current doc set.

- V

[Anonymous User · Accepted solution]

For anyone who is also curious my coworker was able to dig out these 2 links that help to explain it:

https://www.e-education.psu.edu/spatialdb/node/2036

https://gis.stackexchange.com/questions/266461/arcgis-sde-i5-i6-i7-tables