topic Re: How do we rename GLOBALID field name from GlobalID to GLOBALID while having data in FeatureClass? in Geodatabase Questions

How do we rename GLOBALID field name from GlobalID to GLOBALID while having data in FeatureClass?

Vara_PrasadM_S — Fri, 15 Mar 2019 11:52:43 GMT

Hi Team,

Could anyone please tell us if there is a way to rename GlobalId field name. We have ArcSDE on SQL Server DB. When GlobalId field is created the name was given as "GlobalID". We would like to change it to "GLOBALID" (all capitals).

Does the name of this field change in case(all capitals, smalls, camel case etc.,) based on underlying DB? for e.g., on Oracle, field name would be in all capital letters.

Note: we have lot of data in feature class and we want to have same global ids after renaming it.

Thanks in advance!

With Regards,

Vara Prasad

Re: How do we rename GLOBALID field name from GlobalID to GLOBALID while having data in FeatureClass?

Aled_Jones — Fri, 15 Mar 2019 11:59:58 GMT

Hi Vara,

Not sure on Oracles case senstivity.

But to change your field name in ArcSDE - use the AlterField Tool in ArcMap/Catalogue

(Data Management > Fields > Alter Field)

ensure your field name and alias is in caps and I think you're good to go .

I dont think the ID's will change but worth testing in a FGDB.

Ta,

Re: How do we rename GLOBALID field name from GlobalID to GLOBALID while having data in FeatureClass?

Vara_PrasadM_S — Fri, 15 Mar 2019 12:06:24 GMT

Hi Aled,

Thanks so much for quick response.

Does this procedure holds good for FeatureClasses on SQL Server DB?

Thanks a lot!

With Regards,

Vara Prasad

Re: How do we rename GLOBALID field name from GlobalID to GLOBALID while having data in FeatureClass?

Aled_Jones — Fri, 15 Mar 2019 13:12:25 GMT

No Problem Vara.

Yes, this should work for SQL FeatureClasses.

Create a database connection in ArcMap/Catalogue > drag the relevant FeatureClass to the TOC > open the alter field tool > drag the FeatureClass to the "Input Table" parameter > Select "globalid" from Field Name > Enter corrections > run tool

Ta,