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

774
3
03-15-2019 04:52 AM
Vara_PrasadM_S
Occasional Contributor II

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

0 Kudos
3 Replies
Aled_Jones
Occasional Contributor

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,

A

Vara_PrasadM_S
Occasional Contributor II

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

0 Kudos
Aled_Jones
Occasional Contributor

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,

A

0 Kudos