FAQ: Can a Definition Query Be Applied to a Table without an ObjectID or Primary Key Field

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

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

About ObjectID fields

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

Answer

Related Information

Discover more on this topic