SQL geodatabase dbo.i tables?

Anonymous User · ‎06-09-2022

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.

Thank you,

Andrea

Anonymous User · ‎06-13-2022

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

View solution in original post

VinceAngelo · ‎06-10-2022

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 · ‎06-13-2022

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