What SQL dialect does ArcGIS Pro use for SQL expressions on Excel spreadsheets?

445
0
12-03-2022 12:15 AM
Labels (1)
Bud
by
Notable Contributor

What SQL dialect does ArcGIS Pro use for SQL expressions on Excel spreadsheets? Such as a definition query or select by attributes.

The docs seems to have conflicting information:

Query expressions in ArcGIS adhere to standard SQL expressions. The SQL syntax you use within an expression differs depending on the data source. Each data source has its own variant of SQL, which are referred to as SQL dialects.

For example:

  • File-based data, including file geodatabases, shapefiles, in-memory table views, text files such as .dbf.csv.txt.xlsx tables, and feature services that use standardized queries use the ArcGIS SQL dialect that supports a subset of SQL capabilities.
  • Mobile geodatabases, ST_geometrySQLite, GeoPackage, and Excel use SQLiteSQL dialect.
  • Databases or enterprise geodatabases use the SQL syntax of the underlying RDBMS, such as,Oracle,SQL Server,PostgreSQL,SAP HANA, andIBM Db2, where each database uses its own slightly different SQL dialect.

Thanks.

0 Kudos
0 Replies