English

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

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).

Related Information