List of invalid Field Name in Feature Class

[JR99]

Using the .NET SDK, I have found GeodatabaseHelperFunctions.BuildSchema() changes invalid field names however there no function to know which field names have been changed.

When I import a table from within ArcGIS Pro using Display XY Data, I can see that it is changing "Group" to "Group_". This is using the default file geodatabase that is created in the project.

So, clearly there are two elements which contribute towards a valid Field Name, 1. valid characters and 2. valid names, or rather NOT invalid names.

I've found documentation which lists valid/invalid characters but I can't really find the same for words beyond a generic, some words may not be valid.

This issue is causing me a problem when trying to map a DataTable column to the Geodatabase column. i.e. getting an invalid index exception.

For python, there's a ArcPy function ValidateFieldName_management however, .NET SDK does not have an equivilent.

I'm happy to write my own code however, I obviously don't know which names wouild be invalid.
Is there somewhere I can obtain the list of invalid Field Names?

[JR99]

I have managed to find out that SQL reserved words are not valid, however I don't know if this list is exhautive?

ADD

ALTER

AND

AS

BETWEEN

BY

CASE

CHECK

COLUMN

CREATE

DELETE

DROP

EXISTS

FROM

GROUP

HAVING

IN

INSERT

INTO

IS

JOIN

LIKE

NOT

NULL

OR

ORDER

SELECT

TABLE

UPDATE

VALUES

WHERE

[KenBuja · Accepted solution]

This post has several more lists of possible reserved words

[JR99]

Thank you!

Full list for the Esri geodatabase here: FAQ: What Are the Reserved Words for Esri's File Geodatabase?

• ADD
• ALTER
• AND
• BETWEEN
• BY
• COLUMN
• CREATE
• DELETE
• DROP
• EXISTS
• FOR
• FROM
• GROUP
• IN
• INSERT
• INTO
• IS
• LIKE
• NOT
• NULL
• OR
• ORDER
• SELECT
• SET
• TABLE
• UPDATE
• VALUES
• WHERE