English

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 at version 10.0 and before:

• 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
• WHERE

Reserved words within a file geodatabase at version 10.1:

• 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