Frequently asked question

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

Last Published: April 25, 2020

Answer

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

Software:
  • Legacy Products
  • ArcMap

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

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options