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?

344
2
11-03-2021 10:34 AM
VincentLaunstorfer
Occasional Contributor III

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

0 Kudos
2 Replies
ABishop
Regular Contributor II

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-... 

Amanda Bishop, GISP
VincentLaunstorfer
Occasional Contributor III

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.

0 Kudos