Field name length of the enterprise geodatabase tables\layers,

3984
6
Jump to solution
03-13-2014 12:28 AM
JamalNUMAN
Esteemed Contributor
Field name length of the enterprise geodatabase tables\layers,

I have SQL geodatabase (*.mdf) and wanted to know the maximum length the name of a field can take.

[ATTACH=CONFIG]32177[/ATTACH]

Does the name of fields of the file geodatabase take more character than the enterprise geodatabase?



Thank you

Best

Jamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
1 Solution

Accepted Solutions
WilliamCraft
MVP Regular Contributor
In versions of SQL Server 2008 and 2012, the maximum allowable field name length is 31 characters.

Source: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000zw000000

View solution in original post

0 Kudos
6 Replies
WilliamCraft
MVP Regular Contributor
In versions of SQL Server 2008 and 2012, the maximum allowable field name length is 31 characters.

Source: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000zw000000
0 Kudos
WilliamCraft
MVP Regular Contributor
File geodatabase field name length can be up to 64 characters.  

Source: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n00000019000000
0 Kudos
NidhinKarthikeyan
Regular Contributor II
Character limit for Field name in ArcSDE on SQL Server is 31 and Feature Class naming is 128.
0 Kudos
JamalNUMAN
Esteemed Contributor
In versions of SQL Server 2008 and 2012, the maximum allowable field name length is 31 characters.

Source: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000zw000000


Many thanks William and Nidhin for the help

Best

Jamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
deleted-user-0W0-oLHxDjCX
New Contributor III

The problem still persists on ArcGIS 10.4

0 Kudos
User35489
Occasional Contributor III

Similar is case for Oracle Database. Length for Column name could be maximum 31 characters