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

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)]"


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

  • 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