Given a rest endpoint to a MapServer, can we identify if the underlying data source is from fileGDB or SDE?

Question

Is it possible to identify the workspace type (fileGDB or SDE) used in a map service?

Any specific property exposed by the REST API of ArcGIS Server that can help here?

EhabEl-Masry · Answer

if you cannot get this info it from the REST, make it a configuration value.

AntGiles · Answer

One difference I have seen in the SQL between a file geodabase and sqlserver is that a file geodatabase is case sensitive and sqlserver isn't.

geography-matters · Answer

Yes, I think so it may not be possible. Maybe there's an indirect way by using a WHERE sql query that works differently for fileGDB and an enterprise gdb?