________________________________________________________________________________________________
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-name...
SQL Server: https://learn.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sq...
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-s...
PostgreSQL: https://www.postgresql.org/docs/current/sql-syntax-lexical.html
________________________________________________________________________________________________
3. ArcSDE Geodatabase Limits
ArcSDE Geodatabase compared to the RDBMS Object Name Limits.
Enterprise Geodatabase table and field name size length limitations are driven by both the ArcSDE Enterprise Geodatabase and by RDBMS limitations, we need to look into both documentations.
Oracle: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/enterprise-geodatabase...
SQL Server: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/enterprise-geodata...
PostgreSQL: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/enterprise-geodata...
________________________________________________________________________________________________
4. Example
The ArcSDE Geodatabase limitation is 30 characters for field names with the ArcGIS 3.4/11.4 release.
Oracle 19c documentation allows 128 characters for field names.
The Oracle ArcSDE Geodatabase limit of 30 characters takes precedence.
________________________________________________________________________________________________
NOTE: An enhancement request is being worked on the upcoming release of ArcGIS 3.5/11.5 to allow field names with 128 characters for each RDBMS flavor: Oracle / SQL Server / PostgreSQL.
________________________________________________________________________________________________
