PROBLEM

Select by Attributes option for table views in ArcMap is grayed out

Last Published: July 14, 2020

Description

Clicking the Option button on an open attribute table of a geodatabase view, loaded in ArcMap, may show the Select by Attributes option disabled.

Cause

The option is disabled because the view does not have an Object-ID type column. Tables that do not have an Object-ID type column disable the Select by Attributes option.

Solution or Workaround

Registering the view with the geodatabase enables the Select by Attribute option:

[O-Image] Select by Attributes

  1. Select the view in ArcCatalog.
  2. Select the view name.
  3. Select Register with Geodatabase.
Note:
Tables with a column name of ObjectID may not necessarily be an Object ID type. You can verify this in ArcCatalog by right-clicking the layer, selecting Properties, and selecting the Fields Tab in the Table Properties Dialog window. If you don't see the Data Type value listed as ObjectID (Integer, number, etc.)  the Select by Attributes option will be disabled.

Article ID:000002295

Software:
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic