Field Name Length in Enterprise GDB (SQL Server)

2747
4
Jump to solution
01-04-2016 11:02 PM
HaniDraidi
Occasional Contributor II

When I copy a feature class from file GDB to SQL Server enterprise GDB, some fields (their names contain more than 33 characters) are trimmed in the enterprise GDB.

What is the allowed field name length in enterprise GDB? Can I change it?

Thank you in advance,

Hani

1.png

0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor

Hi Hani,

Unfortunately, field names are limited to 31 characters for SQL Server geodatabases:

Enterprise geodatabase size and name limits—Help | ArcGIS for Desktop

However, the field alias can be greater than 31 characters.

View solution in original post

4 Replies
JakeSkinner
Esri Esteemed Contributor

Hi Hani,

Unfortunately, field names are limited to 31 characters for SQL Server geodatabases:

Enterprise geodatabase size and name limits—Help | ArcGIS for Desktop

However, the field alias can be greater than 31 characters.

HaniDraidi
Occasional Contributor II

Many Thanks for the Clarification Jake

0 Kudos
deleted-user-ZMHeMpwIlo8S
New Contributor II

Has there been any development on this limitation?

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

There hasn't been, and I don't expect there will be for a while longer.  See the accepted answer on https://community.esri.com/thread/81043 for a bit more information.

0 Kudos