ERROR

An attribute table with a column name 'GROUP' fails to open from ArcGIS 10.1 when using a file geodatabase

Last Published: April 25, 2020

Error Message

Viewing an attribute table with a column named 'GROUP' fails when using a file geodatabase table. An error similar to the following statement is returned: "An invalid SQL statement was used. [SELECT OBJECTID, NAME, group, id, ORIG_FID FROM testFeatureClass WHERE OBJECTID in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)]"

Cause

The SQL statement includes the reserved word GROUP. GROUP is a reserved word in most RDBMS (ArcSDE), but only became a reserved word at ArcGIS 10.1. Reserved words cannot be used for field names and table names.

Solution or Workaround

Rename the field to something other than a reserved word (GROUP).

Article ID:000011324

Software:
  • ArcMap
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic