ArcSDE Geodatabase Object Name Limitations

MMBR

________________________________________________________________________________________________

1. RDBMS Reserved Words

Each RDBMS has its list of reserved words that must be avoided in table names, and field names.

Oracle: https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpcb/reserved-words-keywords-and-namespaces.html

SQL Server: https://learn.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver16

PostgreSQL: https://www.postgresql.org/docs/15/sql-keywords-appendix.html

________________________________________________________________________________________________

2. RDBMS Limits

We can also find the RDBMS limit of the number of characters in table names and field names in each RDBMS documentation.

Oracle: https://docs.oracle.com/en/database/oracle/oracle-database/23/odpnt/EFCoreIdentifier.html

SQL Server: https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-ver16