AnsweredAssumed Answered

What SQL commands do in_memory workspaces support?

Question asked by rcoodey on Sep 23, 2015
Latest reply on Jul 21, 2018 by bixb0012

In_memory workspaces are great to work with, especially when needing temporary/intermediate steps in an ArcPy script. Currently I am using an arcpy.da.SearchCursor against one and using simple where_clause statements with operators (>, <, =) seem to work just fine. But trying to take it a bit further and use a sql_clause to prefix with a 'DISTINCT' or postfix with a 'ORDER BY' and it doesn't seem to obey those.


Is there any documentation that says what SQL is supported by these in_memory workspaces?


Thanks a lot for any help and information!