Error: An attribute table with a column name 'GROUP' fails to open from ArcGIS 10.1 when using a file geodatabase
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).