Remove the offending attribute. Below is a list of ESRI Geodatabase reserved words and also a MACRO that can be used to regenerate the reserved word list from an article on the ESRI forums.
How do I ensure Valid Attribute Names in Geodatabases
Author Ray Carnes on the ESRI forums
Date Jul 09, 2009
MessagePersonal geodatabase:
ABSOLUTE, ACTION, ADD, ADMINDB, ALL, ALLOCATE, ALPHANUMERIC, ALTER, AND, ANY, ARE, AS, ASC, ASSERTION, AT, AUTHORIZATION, AUTOINCREMENT, AVG, BAND, BEGIN, BETWEEN, BINARY, BIT, BIT_LENGTH, BNOT, BOR, BOTH, BXOR, BY, BYTE, CASCADE, CASCADED, CASE, CAST, CATALOG, CHAR, CHAR_LENGTH, CHARACTER, CHARACTER_LENGTH, CHECK, CLOSE, COALESCE, COLLATE, COLLATION, COLUMN, COMMIT, COMP, COMPRESSION, CONNECT, CONNECTION, CONSTRAINT, CONSTRAINTS, CONTAINER, CONTINUE, CONVERT, CORRESPONDING, COUNT, COUNTER, CREATE, CREATEDB, CROSS, CURRENCY, CURRENT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, DATABASE, DATE, DATETIME, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, DEFERRED, DELETE, DESC, DESCRIBE, DESCRIPTOR, DIAGNOSTICS, DISALLOW, DISCONNECT, DISTINCT, DISTINCTROW, DOMAIN, DOUBLE, DROP, ELSE, END, END-EXEC, ESCAPE, EXCEPT, EXCEPTION, EXCLUSIVECONNECT, EXEC, EXECUTE, EXISTS, EXTERNAL, EXTRACT, FALSE, FETCH, FIRST, FLOAT, FLOAT4, FLOAT8, FOR, FOREIGN, FOUND, FROM, FULL, GENERAL, GET, GLOBAL, GO, GOTO, GRANT, GROUP, GUID, HAVING, HOUR, IDENTITY, IEEEDOUBLE, IEEESINGLE, IGNORE, IMAGE, IMMEDIATE, IN, INDEX, INDICATOR, INHERITABLE, INITIALLY, INNER, INPUT, INSENSITIVE, INSERT, INT, INTEGER, INTEGER1, INTEGER2, INTEGER4, INTERSECT, INTERVAL, INTO, IS, ISOLATION, JOIN, KEY, LANGUAGE, LAST, LEADING, LEFT, LEVEL, LIKE, LOCAL, LOGICAL, LOGICAL1, LONG, LONGBINARY, LONGCHAR, LONGTEXT, LOWER, MATCH, MAX, MEMO, MIN, MINUTE, MODULE, MONEY, MONTH, NAMES, NATIONAL, NATURAL, NCHAR, NEXT, NO, NOT, NOTE, NULL, NULLIF, NUMBER, NUMERIC, OBJECT, OCTET_LENGTH, OF, OLEOBJECT, ON, ONLY, OPEN, OPTION, OR, ORDER, OUTER, OUTPUT, OVERLAPS and OWNERACCESS.
File geodatabase:
ADD, ALTER, AND, AS, ASC, BETWEEN, BY, COLUMN, CREATE, DATE, DELETE, DESC, DROP, EXISTS, FOR, FROM, IN, INSERT, INTO, IS, LIKE, NOT, NULL, OR, ORDER, SELECT, SET, TABLE, UPDATE, VALUES and WHERE.
Enterprise SQL Server 2008/SQL Server Express 2008 geodatabase:
AND, ANY, AS, ASC, AUTHORIZATION, AVG, BACKUP, BEGIN, BETWEEN, BREAK, BROWSE, BULK, BY, CASCADE, CASE, CHECK, CHECKPOINT, CLOSE, CLUSTERED, COALESCE, COLLATE, COLUMN, COMMIT, COMMITTED, COMPUTE, CONFIRM, CONSTRAINT, CONTAINS, CONTAINSTABLE, CONTINUE, CONTROLROW, CONVERT, COUNT, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, DATABASE, DBCC, DEALLOCATE, DECLARE, DEFAULT, DELETE, DENY, DESC, DISK, DISTINCT, DISTRIBUTED, DOUBLE, DROP, DUMMY, DUMP, ELSE, END, ERRLVL, ERROREXIT, ESCAPE, EXCEPT, EXEC, EXECUTE, EXISTS, EXIT, FETCH, FILE, FILLFACTOR, FLOPPY, FOR, FOREIGN, FREETEXT, FREETEXTTABLE, FROM, FULL, FUNCTION, GOTO, GRANT, GROUP, HAVING, HOLDLOCK, IDENTITY, IDENTITY_INSERT, IDENTITYCOL, IF, IN, INDEX, INNER, INSERT, INTERSECT, INTO, IS, ISOLATION, JOIN, KEY, KILL, LEFT, LEVEL, LIKE, LINENO, LOAD, MAX, MIN, MIRROREXIT, NATIONAL, NOCHECK, NONCLUSTERED, NOT, NULL, NULLIF, OF, OFF, OFFSETS, ON, ONCE, ONLY, OPEN, OPENDATASOURCE, OPENQUERY, OPENROWSET, OPENXML, OPTION, OR, ORDER, OUTER, OVER, PERCENT, PERM, PERMANENT, PIPE, PLAN, PRECISION, PREPARE, PRIMARY, PRINT, PRIVILEGES, PROC, PROCEDURE, PROCESSEXIT, PUBLIC, RAISERROR, READ, READTEXT, RECONFIGURE, REFERENCES, REPEATABLE, REPLICATION, RESTORE, RESTRICT, RETURN, REVOKE, RIGHT, ROLLBACK, ROWCOUNT, ROWGUIDCOL, RULE, SAVE, SCHEMA, SELECT, SERIALIZABLE, SESSION_USER, SET, SETUSER, SHUTDOWN, SOME, STATISTICS, SUM, SYSTEM_USER, TABLE, TAPE, TEMP, TEMPORARY, TEXTSIZE, THEN, TO, TOP, TRAN, TRANSACTION, TRIGGER, TRUNCATE, TSEQUAL, UNCOMMITTED, UNION, UNIQUE, UPDATE, UPDATETEXT, USE, USER, VALUES, VARYING, VIEW, WAITFOR, WHEN, WHERE, WHILE, WITH, WORK and WRITETEXT.
I am also sharing an ArcCatalog Macro that generates these keywords so you can create similar lists for other enterprise geodatabases.
To create the Macro:
1) Select the geodatabase you want to generate a list for in the ‘Contents’ tab of ArcCatalog.
2) From the ‘Tools’ menu, select ‘Macros’ and ‘Macros’ and from the dialog that appears, enter a name for the Macro and click ‘Create’.
3) Paste the code below into the Visual Basic Editor, between ‘Sub’ and ‘End Sub’.
4) From the ‘View’ menu in the Visual Basic Editor, select ‘Immediate Window’ so you can see and copy the list of reserved words.
5) From the ‘Run’ menu in the Visual Basic Editor, select ‘Run Macro’ and select and run the Macro name you chose at step 2.
The list of reserved words for the geodatabase type selected will be printed in the Immediate window.
Dim pApp As IGxApplication
Dim pGxObj As IGxObject
Dim pGxDB2 As IGxDatabase2
Dim pSDEWS As IWorkspace
Dim pSQLSyntax As ISQLSyntax
Dim pDBConnInfo As IDatabaseConnectionInfo
Set pApp = Application
Set pGxObj = pApp.SelectedObject
'If for some reason we're not connected to a GDB, Exit
If Not TypeOf pGxObj Is IGxDatabase2 Then
MsgBox "Please select a geodatabase."
Exit Sub
End If
Set pGxDB2 = pGxObj
'Ensure we're connected if using an Enterprise database
If pGxDB2.IsEnterpriseGeodatabase And Not pGxDB2.IsConnected Then
MsgBox "Please connect to the enterprise geodatabase."
Exit Sub
End If
Set pSDEWS = pGxDB2.Workspace
Set pSQLSyntax = pSDEWS
Dim pEnumBSTR As IEnumBSTR
Dim str As String
Set pEnumBSTR = pSQLSyntax.GetKeywords
pEnumBSTR.Reset
str = pEnumBSTR.Next
Do Until str = ""
Debug.Print str
str = pEnumBSTR.Next
Loop
|