I'm wanting to parse through an entire ArcSDE database (feature dataset, features classes, tables, everything...) searching for a field (compkey) and export the numbers to a txt file.
closed as unclear what you're asking by PolyGeo, Chad Cooper, Mapperz♦ May 21 at 13:52
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.
If your data is not versioned (or you've compressed and updated the base tables), you could just use SQL to query out the IDs.
For a manual, one-time-only, type of query, I've used this SQL query (ORACLE) to generate a second SQL query. You could replace the
So the above query will generate a list of select statements with a 'UNION' at the end.
copy/paste that into a new query window (delete the 'UNION' from the last line). and that will give you your list. If you are using SQL Developer or Toad, those applications have built-in capability to export to text file.
If your data is versioned, you should probably look at building multi-versioned views for the versioned featureclasses. Assuming that you would be querying from each featureclass/table at the same version, you could do the same sort of union query but using the multi-version views.