Frequently asked question

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

Last Published: October 5, 2023

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 support with AI

Resolve your issue quickly with the Esri Support AI Chatbot.

Start chatting now

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Start chatting now

Go to download options