Frequently asked question

What syntax is used when creating a table or feature layer based on a query?

Last Published: April 25, 2020


Use SQL, the syntax of the native underlying database. Also keep in mind that these queries do not support all of the functions and statements available in the underlying database. The IQueryDef interface is used to set the query.

Article ID:000005730

  • ArcMap 9 x
  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options