Is there a setting for file geodatabases to force column names in UPPER or LOWER CASE?

111
5
06-26-2019 02:08 AM
Highlighted
Occasional Contributor

I generate feature layers from subsets of data stored in an Oracle database. After some adjustments to the data, such as deleting columns, adding columns and calculating their values I am writing the feature classes into a file geodatabase.

Looking at the column names generated by ArcGIS Pro I am puzzled that auto-generated columns e.g. GEOMETRY_Length have mixed names. Worst, I cannot alter the field name since the field is required...

  • How to adjust/avoid mixed naming?
  • How to force column names to UPPER CASE?
Reply
0 Kudos
5 Replies
Highlighted
Esri Frequent Contributor

I am not sure that this is possible. I know that the RDBMS's handle this differently.

https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/rules-for-creating-spati...

--- George T.
Reply
0 Kudos
Highlighted
Occasional Contributor

I know the guidelines, and hence I find it irritating, to say the least, that Esri database formats allow such things. In our case the geodatabase serves as an exchange format and has to fulfil some naming conventions with respect to the column names before the data are written in to an RDBMS.

Guess I will have a look into Ideas and add it there if not yet existing.

Reply
0 Kudos
Highlighted
Esri Frequent Contributor

Is the mixed case causing any issues, errors, etc?

--- George T.
Reply
0 Kudos
Highlighted
Occasional Contributor

Not as long as we are within the environment of ArcGIS Pro. It gives us some trouble since we cannot control it with respect to the demands coming from the site of the RDBMS. The latter one is not ours and we have to live up to the column naming definition, so the data import can proceed in a standardized way.

Highlighted
Frequent Contributor II

The names you see in Oracle are most likely and Alias.  The names that are coming out of the database are the actual names of the column in the Oracle database.

If you want to change the way the column names look you will need to create and alias. or generate  the table the way you want it as a template and load the data to that table.

To make a permanent change you would need to go into the Oracle database and change the actual names.

   I WOULD NOT RECOMMEND DOING THAT

Reply
0 Kudos