Is it possible to run an arcpy execute SQL method without connecting to any database or server?

Question

I want to simply process a layer by writing a tool script in a toolbox without having to connect any database, so I think I may have to set up a workspace environment in ArcMap, but I'm not sure if I need to do anything else.

Essentially I want to find a Python version of the ArcObjects IWorkspace.ExecuteSQL method.

i'm not that clear what you're asking for, but... have you reviewed the doc for ArcSDESQLExecute ? Edit: also see GP Considerations for working with SDE — gotchula, Dec 31 '12 at 21:20

score 1 · Accepted Answer · edited Apr 13 '17 at 12:34

1

For file geodatabases, I do not think this is possible through arcpy, but it is using GDAL/OGR: ogr2ogr / GDAL remove features in FileGDB while in use by ArcGIS Server map service

edited Apr 13 '17 at 12:34

Community

1

answered Dec 31 '12 at 07:41

blah238

35,793
7
94
195

Is it possible to run an arcpy execute SQL method without connecting to any database or server?

1 Answers1