Frequently asked question

Can a definition query be applied to a table without an ObjectID or primary key field?

Last Published: April 25, 2020


An ObjectID or primary key field is required to perform any selection of features or records in the map. A definition query is a form of selection, and therefore cannot be conducted without the presence of a unique identifier, like a primary key field or an auto-number field.

For additional information and suggestions on how to create an ObjectID field in tables that have none, review the Help documentation in the Related Information below.

Article ID:000009545

  • Legacy Products
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic