This esri document shows field names and index names limit is 128 (SQL Server)
Enterprise geodatabase size and name limits
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/enterprise-geodatabase-limits.htm
But this esri document shows "ArcGIS imposes a limit of 16 characters for attribute index names."
Attribute indexes in the geodatabase
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/attribute-indexes-in-the-geodatabase.htm#GUID-D03A2079-9D75-4293-B73D-6ED23649ABE2
if the limit is 16, this must be a BUG? ArcGIS Enterprise 11.and ArcGIS Pro 3.3/3.4/3.5 should be allowed to create (and maintain) field names and attribute index names up to 128
ArcGIS Pro should not truncate the name down to 16
We should not have to use the SQL Server database tools to create and maintain the attribute index so we can go up to the 128 characters (esri warns about fooling with the enterprise geodatabase directly using SQL Server tools without Enterprise/ArcGIS Pro tools and probably would not /support that)
Any additional details about doing this with traditional versioning, core tables, adds table, delete table, history table, etc.?
This cannot be "as designed" because the 128 change in ArcGIS for filed names has to be the same behavior to create indexes with names up to the limit of the underlying DBMS (128)
Reminds me of the old Arc/Info Coverage limitations shown in this Library of Congress Collection
https://www.loc.gov/preservation/digital/formats/fdd/fdd000284.shtml
Naming restrictions: There are some limitations on the names that can be used by coverages. The following are some limitations on the coverage names:
- Cannot be longer than 13 characters
- Cannot contain spaces
- Cannot start with a number
- Does not have an extension
- Must be in all lowercase letters
And the old ArcGIS 10 Resource Center for Fields in coverage attribute tables
https://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00140000000q000000.htm
INFO uses the following conventions to define the format of each item (field) in a data file:
Item formatDescription
Item name | Any name with up to 16 alphanumeric characters |
Item width | Number of spaces (or bytes) used to store item values |
Output width | Number of spaces (or bytes) used to display item values |
Item type | The data type of the item |
Number of decimals | The number of digits to the right of the decimal place for item types that hold decimal numbers |
Item format definitions
