English
Continue in the app
Be The First To Get Support Updates
Want to know about the latest technical content and software updates?

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

Question

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

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
 

Related Information

Last Published: 9/20/2022

Article ID: 000010906

Software: ArcGIS for Desktop Advanced 10.3, 10.2.2, 10.2.1, 10.2, 10.1 ArcGIS for Desktop Basic 10.3, 10.2.2, 10.2.1, 10.2, 10.1 ArcGIS for Desktop Standard 10.3, 10.2.2, 10.2.1, 10.2, 10.1 ArcGIS-ArcEditor 9.3.1, 9.3, 9.2, 9.1, 10 ArcGIS-ArcInfo 9.3.1, 9.3, 9.2, 9.1, 10 ArcGIS-ArcView 9.3.1, 9.3, 9.2, 9.1, 10 ArcGIS Pro 3.0.1, 3.0, 2.9.4, 2.9.3, 2.9.2, 2.9.1, 2.9, 2.8.7, 2.8.6, 2.8.5, 2.8.4, 2.8.3, 2.8.2, 2.8.1, 2.8, 2.7.7, 2.7.6, 2.7.5, 2.7.4, 2.7.3, 2.7.2, 2.7.1, 2.7, 2.6.9, 2.6.8, 2.6.7, 2.6.6, 2.6.5, 2.6.4, 2.6.3, 2.6.2, 2.6.10, 2.6.1, 2.6, 2.5.2, 2.5.1, 2.5, 2.4.3, 2.4.2, 2.4.1, 2.4, 2.3.3, 2.3.2, 2.3.1, 2.3, 2.2.4, 2.2.3, 2.2.2, 2.2.1, 2.2, 2.1.3, 2.1.2, 2.1.1, 2.1, 2.0.1, 2.0, 1.4.1, 1.4, 1.3.1, 1.3, 1.2