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?

Question

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

VincentLaunstorfer · Answer

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.

ABishop · Answer

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