Provide tool to easily remove the field GLOBALID from feature class.

11-07-2012 12:23 PM
Status: Open
Labels (1)
New Contributor III
There are various approaches to remove the field GLOBALID from a feature class, but this should be something out of the box that takes care of this need.  For those that are quite familiar of the hassle of the lack of current functionality for removal of this field please help by voting to promote this enhancement request.

The below snapshot depicts current esri context menu interface functionality to add Global IDs to a feature dataset's feature classes via a right mouse click on a feature dataset.


The below snapshot portrays what esri could do as one option to help ease the problem to remove the field GLOBALID.


Also request esri enhance their ArcToolbox --> Data Management Tools --> Fields --> Delete Field tool to allow deletion of the field/column of GLOBALID.  In turn this would make the software more robust in model builder and python.

If there is an issue that esri doesn't allow the field to be dropped once created thinking it is still part of versioning, replication or related then esri should likewise enhance their product to unregister as versioned as a preliminary step.

We don't want workaround solutions anymore of VB code, ArcObjects when we don't have an ArcObjects specialist on staff, don't want users have to delete from inside MS Access let alone run a script from within MS Access to remove fields nor do we want to use the Feature Class to Feature Class Tool when we just want to work with the source data.  We just want that straight forward solution that is already nearly at our fingertips per above request.

Thanks for your read and consideration.


Agree with the author we do not want to create or find work-arounds for VBA work-a-arounds that are no longer supported.

We experienced this issue for over 40 datasets and it was rather frustrating referencing the Technical Article.
Who wants to deal with 1 feature class at a time?  
Had to create SQL procedures to automate this as it should be out of the box using the ArcGIS tools. For those that need to automate here was our procedure:
Backup GDB
Drop all Indexes on all owned schema tables for Global ID
Drop all constraints on all owned schema tables for Global ID
Drop Global ID on all owned schema tables
Remove Global ID from SDE column registry
Test your versioned environment
obviously this is a hack but the primary reason a tool is needed that is not 1 feature class at a time. 

We need geoprocessing tool to delete GlobalIds from feature class. We use arcpy and geoprocessing tools to create database migration scripts. Without a proper way to delete GlobalIds we cannot rollback our database changes after GlobalIds are added.