Frequently asked question

What are the reserved words for Esri's file geodatabase?

Last Published: October 5, 2023

Answer

Certain words such as SELECT, DELETE, or UPDATE are reserved and should not be used for identifiers such as table, feature class and column names. Attempting to use a reserved word as a table name will return an error that the table (or feature class) name is invalid. Using a reserved word as a column name will return an error indicating that the column name is invalid. Copy/Paste from a data source where the word is not reserved will add a "_" to the end of any table or column name that is reserved within the file geodatabase.

Reserved words within a 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
 

Article ID:000010906

Software:
  • ArcMap
  • ArcGIS Pro

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic