topic Re: When we create/add GlobalID field to a feature class which is in SQL Server DB, in which case it would get created? in Geodatabase Questions

When we create/add GlobalID field to a feature class which is in SQL Server DB, in which case it would get created?

Vara_PrasadM_S — Fri, 15 Mar 2019 12:01:00 GMT

Hi All,

When we create/add a GlobalID field to a feature class which is in SQL Server (ArcSDE on SQL Server), what would be the default name of the field. Would it be in all capital letters like, GLOBALID or GlobalID or globalid?

Is it possible to rename it while having data in feature class and without loosing data and with same global ids maintained in db.

Thanks in advance!

With Regards,

Vara Prasad

Re: When we create/add GlobalID field to a feature class which is in SQL Server DB, in which case it would get created?

BirajaNayak — Wed, 20 Mar 2019 19:37:30 GMT

The field comes as "GlobalID".

You should not rename it. It will corrupt geodatabase.

It is used as unique identifies in many case such as geodatabase replication and data copy etc.

Here is few help denouements on globalid:

https://support.esri.com/en/other-resources/gis-dictionary/term/4bf5760f-fbed-4378-b8fd-0d9e79630948

http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/add-global-ids.htm

https://support.esri.com/en/technical-article/000016153

Thanks,

Biraja

Re: When we create/add GlobalID field to a feature class which is in SQL Server DB, in which case it would get created?

Vara_PrasadM_S — Fri, 29 Mar 2019 16:55:17 GMT

Thanks a lot Biraja!

Re: When we create/add GlobalID field to a feature class which is in SQL Server DB, in which case it would get created?

DougBrowning — Mon, 25 Jul 2022 21:23:32 GMT

Actual globalid does this also. https://community.esri.com/t5/arcgis-field-maps-questions/field-maps-is-creating-lowercase-globalid-but-agol/m-p/1126721