topic Enterprise GDB 10.6.1 - Is there a geoprocessing tool to run in batch to find out which tables and/or views are registered in Enterprise GDB? in ArcGIS Enterprise Questions

Enterprise GDB 10.6.1 - Is there a geoprocessing tool to run in batch to find out which tables and/or views are registered in Enterprise GDB?

VincentLaunstorfer — Wed, 03 Nov 2021 17:34:40 GMT

Hi,

I am looking for a (an existing?) geoprocessing tool to run in batch to find out which tables and/or views are registered in an Enterprise GDB. This would help to save time...

Thanks

Re: Enterprise GDB 10.6.1 - Is there a geoprocessing tool to run in batch to find out which tables and/or views are registered in Enterprise GDB?

ABishop — Wed, 03 Nov 2021 18:13:26 GMT

Hello @VincentLaunstorfer

I am not sure about a geoprocessing tool to accomplish this task, but there may be a python script? I found this particular thread on the gis stackexchange: https://gis.stackexchange.com/questions/81639/how-to-determine-using-python-whether-arcsde-table-is-registered-with-geodatabas

Re: Enterprise GDB 10.6.1 - Is there a geoprocessing tool to run in batch to find out which tables and/or views are registered in Enterprise GDB?

VincentLaunstorfer — Fri, 05 Nov 2021 14:18:59 GMT

Thanks. This will help...

With SQL, I will run a query to list tables with a ST_GEOMETRY (spatial table) column type which are not in GDB_ITEMS system table. These should be the unregistered spatial tables.

Also, I will run a reverse SQL query to list registered tables in GDB_ITEMS which do not exist in the RDBMS, meaning the records in GDB_ITEMS are of no use and obsolete.